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

Screenshot of emschwartz.me: Short-Circuiting Correlated Subqueries in SQLite

First screen, captured 10 months ago.

Looks similar

Screenshot of emschwartz.me: Subtleties of SQLite Indexes

Subtleties of SQLite Indexes (emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments

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

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

152 points by Maksadbek 3 years ago | 57 comments

Screenshot of craigkerstiens.com: Postgres feature you're not using – CTEs a.k.a. WITH clauses

Postgres feature you're not using – CTEs a.k.a. WITH clauses (craigkerstiens.com)

71 points by plaur782 2 years ago | 24 comments

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

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 database-performance benchmarks clojure

Screenshot of blog.tansu.io: Small Kafka: Tansu and SQLite on a free t3.micro

Small Kafka: Tansu and SQLite on a free t3.micro (blog.tansu.io)

93 points by rmoff 9 months ago | 20 comments

Screenshot of emschwartz.me: Building docs like a product

Building docs like a product (emschwartz.me)

58 points by emschwartz 8 months ago | 6 comments

Looks similar

Subtleties of SQLite Indexes(emschwartz.me)

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

Postgres feature you're not using – CTEs a.k.a. WITH clauses(craigkerstiens.com)

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

Small Kafka: Tansu and SQLite on a free t3.micro(blog.tansu.io)

Building docs like a product(emschwartz.me)