Get the latest tech news

SQLite JSON at full index speed using generated columns

One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.

None

Get the Android app