Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
The Replication Lag Question That Shows Up in Most Senior Interviews
Cover image for The Replication Lag Question That Shows Up in Most Senior Interviews

The Replication Lag Question That Shows Up in Most Senior Interviews

Comments
7 min read
URL Shortener Design: The Capacity Math 90% of Candidates Get Wrong
Cover image for URL Shortener Design: The Capacity Math 90% of Candidates Get Wrong

URL Shortener Design: The Capacity Math 90% of Candidates Get Wrong

Comments
7 min read
The CAP Theorem Question Every Senior System Design Interview Asks
Cover image for The CAP Theorem Question Every Senior System Design Interview Asks

The CAP Theorem Question Every Senior System Design Interview Asks

Comments
7 min read
Why Your Caching Strategy Probably Has the Same 4 Holes
Cover image for Why Your Caching Strategy Probably Has the Same 4 Holes

Why Your Caching Strategy Probably Has the Same 4 Holes

Comments
7 min read
How to Design Uber's Dispatch System (and Why H3 Beat Geohash)
Cover image for How to Design Uber's Dispatch System (and Why H3 Beat Geohash)

How to Design Uber's Dispatch System (and Why H3 Beat Geohash)

Comments
7 min read
Twitter's Fanout Strategy at Scale: The Trade-Off Most Designs Miss
Cover image for Twitter's Fanout Strategy at Scale: The Trade-Off Most Designs Miss

Twitter's Fanout Strategy at Scale: The Trade-Off Most Designs Miss

Comments
9 min read
Sharding Strategies in 2026: Range, Hash, Geo, Directory — Which Wins When
Cover image for Sharding Strategies in 2026: Range, Hash, Geo, Directory — Which Wins When

Sharding Strategies in 2026: Range, Hash, Geo, Directory — Which Wins When

Comments
7 min read
Designing a Web Crawler That Scales to 1 Billion Pages a Day
Cover image for Designing a Web Crawler That Scales to 1 Billion Pages a Day

Designing a Web Crawler That Scales to 1 Billion Pages a Day

Comments
7 min read
Why I built a High-Performance Vector Database in Rust (and why it’s now Open Source)

Why I built a High-Performance Vector Database in Rust (and why it’s now Open Source)

Comments
2 min read
Azure Migration Is Not the Problem. Your Plan Is
Cover image for Azure Migration Is Not the Problem. Your Plan Is

Azure Migration Is Not the Problem. Your Plan Is

Comments
4 min read
MySQL 的 MVCC:看不见的“时间机器”怎么帮你躲过脏读和幻读?

MySQL 的 MVCC:看不见的“时间机器”怎么帮你躲过脏读和幻读?

Comments
1 min read
Notion Database Limits & Workarounds — 7 Walls Every Power User Hits

Notion Database Limits & Workarounds — 7 Walls Every Power User Hits

Comments
3 min read
We measured 72% 91% accuracy on Text-to-SQL over a 600-table ERP - what actually fixed it
Cover image for We measured 72% 91% accuracy on Text-to-SQL over a 600-table ERP - what actually fixed it

We measured 72% 91% accuracy on Text-to-SQL over a 600-table ERP - what actually fixed it

2
Comments 1
2 min read
Automating Data Workflows with Apache Airflow
Cover image for Automating Data Workflows with Apache Airflow

Automating Data Workflows with Apache Airflow

1
Comments
6 min read
How I Built a Scalable and Secure Streaming Backend with Python (Production Lessons)

How I Built a Scalable and Secure Streaming Backend with Python (Production Lessons)

Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.