Awesome database stories from the best
The article presents a curated list of notable database stories and optimizations. It highlights various techniques and improvements made in popular databases like Postgres, SQLite, and MySQL. Each entry includes the date, a brief summary, and the author of the respective story.
- ▪The article features stories on optimizing database performance and scalability.
- ▪Notable entries include techniques for improving SQLite speed and managing large datasets in Postgres.
- ▪The list includes contributions from various authors, showcasing diverse approaches to database challenges.
Opening excerpt (first ~120 words) tap to expand
⚡️ Awesome Database A curated list of awesome database stories. Date Summary w/ link Author 2026/02/13 How We Optimized Top K in Postgres Ming Ying 2026/03/05 How Pinecone Safely Deletes Billions of Objects at Scale Hirad 2024/12/22 How bloom filters made SQLite 10x faster @avinassh 2025/11/13 35% Faster Than The Filesystem @sqlite 2025/11/13 How MySQL Avoids Performance Hits from Table Scans @arpitbbhayani 2025/01/09 Database Sharding @bddicken 2024/14/12 Faster SQLite @avinassh 2026/22/01 Scaling PostgreSQL to power 800 million ChatGPT users Bohan Zhang 2024/11/12 A simple guide to ClickHouse query optimization: part 1 @lio-p 2021/25/03 SQLite is not a toy database antoz 2024/06/06 how Stripe’s document databases supported 99.999% uptime with zero-downtime data migrations Jimmy Morzaria…
Excerpt limited to ~120 words for fair-use compliance. The full article is at GitHub.