SQLite Forum

Efficient array data type
Login
Hi,
I'm trying to figure out if sqlite, or one of its extensions, supports efficient storage of arrays of various data types. For the problem at hand, of numbers and dates, but in general, of any SQLite supported data type.

Looking around it seems that:

* The core SQLite does not support arrays
* The CArray extension, despite the name, does something else
* The JSON1 extension supports, among other things, arrays, but stores them as strings, thus not in a space efficient way for numbers and dates.

Am I missing anything here? 

Best regards
Andrea