SQLite as a Document Database (2020)

dgl.cx projects about ✨ ☀️ ☁️ SQLite as a document database SQLite has had JSON support for a while. However recently it added a killer feature: generated columns. (This was added in 3.31.0, released 2020-01-22.) This makes it possible to insert JSON straight into SQLite and then have it extract data and index them, i.e. you can treat SQLite as a document database. This has been possible with PostgreSQL and obviously is what something like Elastic provides but having it available in an embedded