Things that surprised me while running SQLite in production(joseferben.com)

181 points by joseferben 3 years ago | 94 comments

Short-Circuiting Correlated Subqueries in SQLite(emschwartz.me)

6 points by emschwartz 10 months ago | 0 comments

100k TPS over a billion rows: the unreasonable effectiveness of SQLite(andersmurphy.com)

344 points by speckx 10 months ago | 124 comments

Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.

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

152 points by Maksadbek 3 years ago | 57 comments

Subtleties of SQLite Indexes(emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments

Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries(sql.ophir.dev)

21 points by lovasoa 3 years ago | 8 comments