LINKED LIST [txt mode] ▸ SQLite JSON Superpower: Virtual Colum...

home explore | log in

SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog

dbpro.app · first added by @hnl · 2026-02-27 · 2 upvotes

log in to save, upvote or flag this.

─── In 1 list ──────────────────────────────────────────

* Issue #775 by @hnl [data]

─── Discussions ────────────────────────────────────────

* SQLite JSON at full index speed using generated columns

381 pts · 114 comments · node

─── From the discussion ────────────────────────────────

* Indexes On Expressions

sqlite.org · node

* SQLite Functions for Working with JSON

sqlite.org · node

* Indexing JSONB in Postgres | Crunchy Data Blog

crunchydata.com · node

* MySQL :: MySQL 8.4 Reference Manual :: 15.1.15 CREATE INDEX Statement

dev.mysql.com · node

* GitHub - fsaintjacques/recordlite

github.com · node

─── Related hn threads ─────────────────────────────────

* SQLite Functions for Working with JSON

193 pts · 52 comments · node

─── Also saved alongside this ──────────────────────────

* ALPR Watch – Track Surveillance Tech in Local Government

3 upvotes · 2026-02-27

* Thin Desires Are Eating Your Life

1 upvotes · 2026-02-27

* Your job is to deliver code you have proven to work

3 upvotes · 2026-02-27

* AI agents are starting to eat SaaS

2 upvotes · 2026-02-27