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 database is very nice for lightweight stuff.

Let's get started:

$ sqlite3 SQLite version 3.31.1 2020-01-27 19:55:54 Connected to a transient in-memory database.…