

Blog
Explore the articles
Practical guides to .NET, databases and distributed systems. Newest articles first.
Showing 1–12 of 20 articles about databases.


How Notion Stores Pages, Blocks and Databases
Explore Notion's block model and PostgreSQL architecture, with practical examples of page structure, permissions, workspace sharding and collaborative edits.

How Discord Stores Trillions of Messages
Learn how Discord organises message storage and search, with clear examples of time buckets, hot partitions, queues, retries and reliable chat history.

How Pinterest Stores Pins, Boards and Saved Content
Explore Pinterest's published MySQL design, with practical examples of objects, board mappings, caching, image references, sharding and reliable saves.

How Facebook Stores Data: Posts, Friendships and the Social Graph
Explore Facebook's published storage architecture, from social graphs and MySQL to caching, sharding and consistency, with practical engineering examples.

UUIDv4 vs UUIDv7 vs ULID: Choosing IDs for a Database
Read article
What Happens When Two Regions Update the Same Record?
Read article
Quorums Explained: How Many Servers Need to Agree?
Read article
Why Deleted Data Can Come Back in a Distributed System
Read article
How to Move Data Between Database Servers While Your App Keeps Running
Read article
When Two Services Disagree: Finding and Fixing Data Mismatches
Read article