SQLite JSON at full index speed using generated columns(dbpro.app)

334 points by upmostly 10 months ago | 102 comments

A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.

SQLite Is All You Need(dbpro.app)

35 points by upmostly 3 months ago | 38 comments

Parsing the Postgres protocol – logging executed statements(kviklet.dev)

76 points by jascha_eng 2 years ago | 14 comments

SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s(phiresky.github.io)

152 points by Maksadbek 3 years ago | 57 comments

Show HN: How SQL Parsers Work(nishchith.com)

11 points by inishchith 9 months ago | 1 comments

Run Database in GitHub Actions, Persisting Data to S3, and Access It Publicly(wesql.io)

53 points by earayu 1 year ago | 36 comments