SQLite as a Document Database (2020)
Summary
The article shows how SQLite can function as a lightweight document database by leveraging JSON support and generated columns. It includes practical examples for creating virtual and stored generated columns, enforcing constraints, and indexing JSON-derived data within an embedded database. A solid reference for developers seeking embedded JSON querying without a separate document store.