Templates
System design templates
50 architecture boards you can read as an article and open as a board. Each one is a diagram with a narrated walkthrough through it; most also carry written requirements, capacity and storage estimates, an availability plan and a real database schema. They are the questions that get asked in system design interviews, drawn rather than described.
Messaging & realtime
Delivery, presence, ordering, and who is typing.
Chat and messaging - one socket, many deliveries
Delivery guarantees, presence and ordering across devices.
Transactional email - the receiver decides
queues, backoff, bounces and complaints - and SPF, DKIM and DMARC as parts of the architecture rather than a checklist
Presence - the most expensive cheap feature
heartbeats, TTL, and why one green dot costs more events per day than every message in the product
Push notifications - the token outlives the install
APNs and FCM, token lifecycle, batching, and why a dead token beats a failed send to the top of the incident list
Team channels - the unread count is the hard part
channel fan-out against DM, threads that do not bump the room, and the badge nobody wants to store
Encrypted delivery - one tick, two ticks, blue
sent, delivered, read - and what a server that cannot read the message is allowed to claim
Video & media
Upload, transcode, deliver - and pay for the bandwidth.
Image CDN - resize on the fly, or store every size
Cache keys, on-demand transforms, and the tail that never hits cache
Live streaming - latency against the buffer that saves you
Ingest, segmenting, and the real cost of every second of latency removed
Streaming playback - the bytes were already next to you
Manifest, adaptive bitrate, edge appliances and pre-positioned content
Transcoding pipeline - 480 tasks, one file
Job queue, worker pools, codecs and what a failed segment costs
Video upload - one file in, seven encodes out
Resumable upload, the transcode fan-out, and why it says processing
Marketplaces & booking
Two-sided systems where inventory must not be sold twice.
Checkout - holding stock you have not sold yet
reserve, charge, commit, unwind
Auction bidding - the clock is part of the system
ordering, proxy bids, soft close
Food delivery - three parties and a promise
state machine, offers, ETA
Hotel booking - selling a range, on purpose, slightly twice
nights, holds, overbooking, cancellation
Seat sales - fifty thousand people, one hundred seats
queue, hold, expire, issue
Infrastructure primitives
The building blocks an interview asks you to build from scratch.
URL shortener - one write, a million reads
One write, millions of reads. The warm-up question.
Distributed cache - the ring, and what a node leaving costs
consistent hashing, hot keys, and the miss storm
Key-value store - quorums, and where the consistency knob sits
partition, replicate, and choose how much to wait for
Rate limiter - token bucket, and where the counter lives
allow, deny, and the shared counter in between
Unique ID generator - 64 bits, and two facts nobody can check
time, machine, sequence - and the clock going backwards
Web crawler - a frontier, and the trap of crawling forever
fetch politely, dedup honestly, never loop
Payments & ledgers
Systems where losing a write is losing money.
Double-entry ledger - the balance is not a column
Teaches why money is stored as immutable movements and read as a derived sum, and what it costs to never update a total.
Fraud detection - a decision that must fit in 120 milliseconds
Teaches how a risk decision is split between a synchronous call with a hard deadline and an asynchronous review that is allowed to be right.
Payment gateway - what a timeout means when the card may already be charged
Teaches how a payment system stays correct when its authoritative dependency can fail in a way that tells you nothing.
Matching engine - price-time priority, and why the clock cannot decide who was first
Teaches why an exchange assigns order with a sequence number instead of measuring it with a clock, and what a single-threaded book buys in return.
Wallet transfers - the state machine, the hold that expires, and the reversal that cannot
Teaches how money moves between two accounts in one system without ever being in both places or neither, and what it costs to make every step undoable.
Data & analytics
Pipelines, metrics and the lag between event and answer.
Ad serving - an auction inside a page load
Why a system with eighty milliseconds to decide must spend money it cannot yet count.
Analytics pipeline - the lag between an event and the answer
Why a click takes ten seconds to reach one dashboard and until tomorrow to reach the one people trust.
Log aggregation - the index is bigger than the data
Why searching your logs costs thirteen times more than keeping them, and what you can no longer ask once you sample.
Metrics and monitoring - cardinality is the thing that kills you
Why one label with unbounded values takes down the system that was supposed to explain the outage.
Recommendation engine - retrieve a thousand, rank twenty
Why the feed is computed in a hundred milliseconds by a model that is a day out of date.
Location & logistics
Geospatial indexes, matching and moving things.
Fleet tracking - 21,600 writes per vehicle per day
Teaches how a continuous position firehose is split into a tiny live picture and an enormous history, and how retention rather than hardware decides what it costs.
Geofencing - many points against many polygons
Teaches how a covering index reduces every-point-against-every-fence to a handful of tests, and why a jittery GPS makes the crossing itself the harder problem.
Maps routing - precompute, then watch it go stale
Teaches how a shortest path over a continental road graph is bought with precomputation, and what live traffic does to work that was done last night.
Proximity search - the index is the design
Teaches how to size a geospatial index against the query it serves, and why the nearest answer is usually in the cell next door.
Ride matching - the nearest car is the wrong car
Teaches how a geospatial index turns supply and demand into a dispatch decision, and why that decision is an assignment over a batch rather than a nearest-neighbour lookup.
Collaboration
Several people editing one thing without losing an edit.
Calendar scheduling - a time that suits five people
Why a meeting time is computed from rules and guesses rather than read from a table, and what that costs.
Code review - the comment is on a line that moved
What it takes to keep a conversation attached to code that is rewritten underneath it while the conversation is still going.
Collaborative editor - two carets in one paragraph
How two people type into one document at the same time without either of them losing a character.
Version control - the commit graph is a DAG
Why history is a graph rather than a list, and what that costs at merge, at fetch and at garbage collection.
Whiteboard sync - the cursors cost more than the drawing
Why a shared canvas is mostly a broadcast problem, and what happens to a shape that two people grab at once.
Database schemas
Entity boards that Generate SQL turns into real DDL.
Opening one
The two free boards are written out in full. Every other page states the problem the board solves and what it has to do, and the board itself - the walkthrough, the written pages and the schema - opens in Tierslate: a canvas, a walkthrough player that steps through a diagram one wire at a time, and a schema lens that turns entity boards into SQL.
Social & feeds
Timelines, follows, fan-out - the read-heavy classics.
Social news feed - fan-out on write or on read
Fan-out on write against fan-out on read, and when each loses.
System design · core
Media feed - the feed serves URLs, the edge serves bytes
direct upload, rendition pipeline, and who actually pays for the pixels
System design · core
The professional graph - degrees, and why it is not a join
in-memory adjacency, bidirectional BFS, and an offline people-you-may-know
System design · deep
Comment trees - one range scan, and four writes per vote
materialized paths, ranked subtrees, and the write amplification of a vote
System design · deep
The social graph - one edge, written twice
adjacency in both directions, follow against friend, and counters that drift
System design · core
Home timeline - materialise it, then keep it honest
fan-out on write, the celebrity exception, and the hydrate hop
System design · core