Trade-offs library.
22 in-depth study guides for the trade-offs that come up in every system design interview and production design review. Each page is a complete 2,000–2,800 word teaching chapter with a comparison table, real-world systems, decision checklist, and flashcards.
- Guides
- 22
- Categories
- 5
- Words
- 51,492
- Format
- 13-section
Data & Storage
5 guides- Data & Storage
SQL vs NoSQL
When relational wins, when non-relational wins, and why 'SQL does not scale' is almost always wrong in 2026.
15 min - Data & Storage
B-tree vs LSM-tree Storage
Decision guide for choosing between B-tree and LSM-tree storage engines based on read:write ratio, latency SLOs, and operational complexity.
15 min - Data & Storage
Partitioning Schemes: Range, Hash, Consistent Hash, Directory
Decision guide for the four canonical partitioning strategies. Pick based on query pattern, rebalance cost, and hot-spot risk.
20 min - Data & Storage
Normalization vs Denormalization
Decision guide for choosing between strict 3NF schemas and redundant pre-joined data, with the hybrid CDC-projection pattern most production systems actually run.
15 min - Data & Storage
ACID vs BASE
When ACID transactions earn their coordination cost, when BASE is the only thing that scales, and why most systems run both.
15 min
Consistency & Replication
5 guides- Consistency & Replication
Strong vs Eventual Consistency
Quick reference: when to pick linearizable consistency, when eventual is enough, and the session-guarantees hybrid that most production systems actually run.
15 min - Consistency & Replication
CAP and PACELC Applied
Decision guide for picking CP or AP under partition, and why PACELC's else-clause (latency vs consistency) is the choice you face on every request.
15 min - Consistency & Replication
Replication Topologies: Leader-Follower, Multi-Leader, Leaderless
Decision guide for picking how writes propagate: single-leader, multi-leader, leaderless, or per-range-leader hybrid.
15 min - Consistency & Replication
Distributed Transactions: 2PC vs Saga vs TCC
Decision guide for choosing between two-phase commit, saga compensations, and try-confirm-cancel based on isolation needs, transaction duration, and participant control.
15 min - Consistency & Replication
Optimistic vs Pessimistic Concurrency Control
Decision guide for picking validate-at-commit vs lock-first concurrency. The answer depends on conflict rate, retry cost, and side effects.
15 min
Performance & Scale
5 guides- Performance & Scale
Latency vs Throughput
When to optimize for the single request, when to optimize for the aggregate, and why batching has a non-obvious ceiling.
15 min - Performance & Scale
Vertical vs Horizontal Scaling
Decision guide for scaling up a single machine vs scaling out across many. Default: vertical first, horizontal only when measured bottlenecks demand it.
15 min - Performance & Scale
Cache Strategies: Cache-Aside vs Write-Through vs Write-Behind
Decision guide for picking the right cache-database coordination pattern: what you gain, what you lose, and why most systems use a hybrid.
15 min - Performance & Scale
Rate Limiting Algorithms: Token Bucket vs Sliding Window
Decision guide for picking the right rate-limiting algorithm. Token bucket tolerates bursts; sliding window enforces accuracy; the hybrid path layers both.
15 min - Performance & Scale
Single-Region vs Multi-Region Deployment
Decision guide for deployment geography: single-region is the default, multi-region is the most expensive choice you can make, and regional pinning is the hybrid most teams actually need.
15 min
Architecture & APIs
3 guides- Architecture & APIs
Monolith vs Microservices
Decision guide for the architecture choice that mirrors your org chart. Team size and domain stability decide, not traffic.
15 min - Architecture & APIs
REST vs gRPC vs GraphQL
Decision guide for picking the right API protocol based on caller identity, caching needs, and payload shape.
15 min - Architecture & APIs
Load Balancer vs Reverse Proxy vs API Gateway
Decision guide for choosing between L4 load balancers, L7 reverse proxies, and API gateways based on your traffic layer, protocol, and policy needs.
15 min
Messaging & Streaming
4 guides- Messaging & Streaming
Batch vs Stream Processing
Decision guide for choosing discrete job runs vs continuous flow, pinned to the freshness SLO that actually matters.
15 min - Messaging & Streaming
Lambda vs Kappa Architecture
Decision guide for choosing two pipelines (batch + stream) vs one (stream-only with log replay) for analytics data systems.
15 min - Messaging & Streaming
Polling vs Long-Polling vs SSE vs WebSockets vs Webhooks
Decision guide for picking the right real-time pattern. Five options, each right for a different niche; the wrong one means missed updates, wasted bandwidth, or operational pain.
15 min - Messaging & Streaming
Push vs Pull (Fan-out, Messaging, Feed)
Decision guide for the fundamental data-propagation choice: push front-loads compute on writes, pull back-loads it on reads. The fan-out ratio decides.
15 min
No trade-offs match that search
Try a different query, or clear the filters.