

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


Cache Invalidation in Distributed Systems: Keeping Cached Data Consistent
Read article
Distributed Locks, Leases and Fencing Tokens: Preventing Stale Workers from Corrupting Data
Read article
System Design Interview: Design Adaptive Video Streaming at Scale
Read article
How to Scale Likes, Comments and View Counts Without Hot Database Rows
Read article
How GitHub Stores Code, Commits and Repository History
Learn how Git objects, branches and packfiles work alongside GitHub's hosting and application data, with examples of pushes, replication and recovery.

Capacity Planning for System Design: How Many Servers Do You Need for Millions of Users?
Read article
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 Figma Stores Design Files and Version History
Understand Figma's published multiplayer storage design, including structured files, checkpoints, journals, offline edits and recoverable version history.

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.
