Skip to content

Anders Murphy personal blog

100k TPS over a billion rows: the unreasonable effectiveness of SQLite

andersmurphy.com 11 min read

A blog mostly about Clojure programming

Read on andersmurphy.com → Discuss on HN (159) Archived copy

Points: 423
HN comments: 159
Submissions: 1
Cited by: 0 commenters

Databases & Data Systems & Performance 2025

On Hacker News

Submitted	Title on HN	Points	Comments
Dec 2, 2025	100k TPS over a billion rows: the unreasonable effectiveness of SQLite by speckx	423	159

More from Anders Murphy

All 4 posts →

The perils of UUID primary keys in SQLite

2026184 points108 comments Databases & Data details

Clojure: Realtime collaborative web apps without ClojureScript

2025172 points34 commentscited by 3Software Engineering details

Clojure: Managing throughput with virtual threads

2024165 points15 comments Software Engineering details

Related posts from the same era

ICE using Palantir tool that feeds on Medicaid data

EFF Deeplinks20261,475 points969 comments details

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

Tracking down the 16-year-old WAL-reset SQLite bug

Tailscale Blog20261,223 points239 commentscited by 3 details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

PGSimCity - How PostgreSQL Works

nikolays.github.io2026930 points90 comments details