

Blog
Explore the articles
Practical guides to .NET, databases and distributed systems. Newest articles first.
Showing 61–72 of 111 articles.


How Uber Stores and Queries Driver Location Data
Explore Uber's published spatial and trip architecture, with clear examples of H3, location freshness, nearby searches, out-of-order updates and matching.

How Reddit Stores Posts and Nested Comment Threads
Learn how Reddit's published comment architecture connects PostgreSQL, caching and change events, with practical examples of threads, votes and moderation.

How Spotify Stores Playlists and Listening History
Understand Spotify's playlist versions and event pipelines, with practical explanations of ordering, listening history, duplicates and personalisation data.

System Design Interview - Messaging App Like WhatsApp
Read article
System Design Interview - Big Tech Data Storage
Read article
System Design - How to Approach the Problem
Read article
System Design Interview - E-Commerce Platform
Read article
System Design Interview: Salesforce CRM
Read article
System Design Interview: Unique Identifier for Distributed Systems
Read article
System Design Interview: Online Auction Platform
Read article