DB Pro Blog company blog
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.
- Points
- 381
- HN comments
- 114
- Submissions
- 1
- Cited by
- 0 commenters
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Dec 12, 2025 | SQLite JSON at full index speed using generated columns by upmostly | 381 | 114 |
