#1 2020-12-27 07:25:06

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 wink


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

Offline

#2 2020-12-27 08:45:33

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.

Offline

#3 2020-12-27 18:50:21

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,609
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.

Offline

Board footer

Powered by FluxBB