Low Level Design: Database Index Selection Strategy
4 min read Database indexes dramatically accelerate query performance by providing direct access paths to rows, avoiding full table scans. However, indexes consume […] Read article
System Design
System Design
Low Level Design: Cursor-Based vs Offset Pagination
6 min read Pagination enables clients to retrieve large result sets page by page instead of in one response. Two primary approaches exist: Read article
System Design
Low Level Design: Write-Ahead Log (WAL) Design
6 min read The Write-Ahead Log (WAL) is the foundation of database durability and crash recovery. Every change to database state is first Read article
System Design
Low Level Design: CRDTs (Conflict-Free Replicated Data Types)
6 min read CRDTs (Conflict-Free Replicated Data Types) are data structures that can be updated independently and concurrently on multiple nodes without coordination, Read article
System Design
Low Level Design: OAuth2 and OIDC Implementation
6 min read OAuth2 is an authorization framework that allows users to grant third-party applications limited access to their accounts without sharing passwords. Read article
System Design
Low Level Design: MVCC Database Concurrency Control
4 min read Multi-Version Concurrency Control (MVCC) is the concurrency mechanism used by PostgreSQL, MySQL InnoDB, Oracle, and most modern databases to enable Read article
System Design
Low Level Design: GraphQL API Design
6 min read GraphQL is a query language for APIs where clients specify exactly the data they need and receive nothing more. Unlike Read article
System Design
Low Level Design: Geo-Spatial Indexing
4 min read Geo-spatial indexing enables efficient queries on geographic data: finding restaurants within 1km, matching drivers to riders within 500m, showing events Read article
System Design
Low Level Design: WebSocket Server at Scale
6 min read WebSocket provides full-duplex, low-latency communication between a browser and server over a single persistent TCP connection. Unlike HTTP polling (client Read article
System Design
Low Level Design: Full-Text Search Index Design
6 min read Full-text search finds documents matching natural language queries across large corpora. Unlike exact-match database queries (WHERE name = ‘foo’), full-text Read article
System Design
Low Level Design: Audit Logging System
5 min read An audit log records a tamper-evident, chronologically ordered history of all significant actions in a system: who did what, when, Read article
System Design
Low Level Design: gRPC Service Design
3 min read gRPC is a high-performance RPC framework built on HTTP/2 and Protocol Buffers. It provides strongly-typed service contracts, efficient binary serialization, Read article
System Design
Low Level Design: Real-Time Leaderboard
5 min read A real-time leaderboard ranks users or entities by a score that updates continuously. The core challenge is serving low-latency rank Read article
System Design
Low Level Design: Zero-Downtime Deployment
3 min read Zero-downtime deployment updates production services without dropping user requests. Modern techniques — rolling updates, blue-green deployments, and canary releases — Read article
System Design
Low Level Design: SLI, SLO, and Error Budget Design
5 min read SLIs (Service Level Indicators), SLOs (Service Level Objectives), and error budgets are the quantitative framework for reliability engineering. An SLI Read article