3 ms·
I'd argue that the more large/complicated/nested the JSON structure, the more it would benefit from using a "real" database instead of a JSON file sitting on di
by zackelan 9y ago
I'd argue that the more large/complicated/nested the JSON structure, the more it would benefit from using a "real" database instead of a JSON file sitting on disk. If not SQLite due to document-relational mismatch, then LevelDB, RocksDB, or one of the other embedded key-value stores.
Of course, SQLite can also emulate a key-value store quite well, with a table with 'key' and 'value' columns.
- mythrwy 9y agoAlso the JSON1 extension. https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html