mORMot Open Source

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

SQLite as a document database

I'd like to share with you a very useful article about using the JSON and 'generated columns' features of SQLite for storing scheme-less documents:
https://dgl.cx/2020/06/sqlite-json-support

SQLite is sssssssoooooooooo powerful! I'm glad that @ab had the envision on it and have chosen it as the foundation as mORMot

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

AOG

Member

Registered: 2014-02-24

Posts: 490

Re: SQLite as a document database

I would (also) welcome the implementation of sqlite3-json features. Trying to be future-proof, all my complex objects are stored as json in sqlite3. Would be good to have dedicated json-features for speed-reasons.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: SQLite as a document database

The JSON extension (SQLITE_ENABLE_JSON1 conditional) is included in our current static versions of SQLite3.

So you can use those generated columns + JSON directly.