mORMot Open Source

Codorna

Member

Registered: 2018-06-26

Posts: 21

Is it possible to store an array as JSON on SQLite?

I've been searching for it but I couldn't find an answer, would it be possible to store it as JSON instead of BLOB?

from what I've read, TObjectList would store it as json, but would add a class: property that I don't want, and i've never worked with Collections, TDocVariant would be problematic for me since I like the type-safety.

If I can't do with an array what would be the best way to have it type safe while storing it as a json?

Thanks

Last edited by Codorna (2018-07-21 20:48:56)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: Is it possible to store an array as JSON on SQLite?

Use a T*ObjArray published property.