SQLite as a Document Database
SQLite as a Document Database (2020)
SQLite's JSON support, combined with generated columns, lets you treat it as a document database. This post shows how to insert JSON, extract fields into virtual columns, enforce constraints, and index them—all in an embedded database. It's ideal for lightweight apps and webhooks, allowing flexible schemas without a separate document store.
It's that simple, the `d` column is extracted from the provided JSON.