Build your own document database with SQLite.

Anton Z's resource offers insights, tutorials, and resources for software developers and technology enthusiasts. Readers can learn about coding best practices, software architecture patterns, and emerging technologies. With articles, tutorials, and code samples, Anton Z provides  guidance and expertise for building software applications and advancing technical skills.

Anton Zhiyanov

This post discusses the concept of generated columns in SQLite and how they can be used to calculate values based on other columns in the same table. It also explores a common use case of extracting JSON paths into separate columns and indexing them. Generated columns allow SQLite to be used as a document database by storing documents as JSON blobs and extracting fields as needed.

Modern SQLite: Generated columns