Logo
Search
Home
Archive
Categories
Login
Sign Up
Logo

System Design

This contain the blogs related to system design

System Design

How to count to a billion with 12KB of RAM.

Jan 29, 2026

•

4 min read

How to count to a billion with 12KB of RAM.

Issue #029: The magic of HyperLogLog.

Harsh Kathiriya
Harsh Kathiriya

System Design

Why standard databases are slow at writing.

Jan 28, 2026

•

4 min read

Why standard databases are slow at writing.

Issue #028: B-Trees vs. LSM Trees (and why Discord uses Cassandra)

Harsh Kathiriya
Harsh Kathiriya

System Design

Stop checking the database

Jan 27, 2026

•

4 min read

Stop checking the database

Issue #027: How to check 1 billion items in milliseconds with 50MB of RAM.

Harsh Kathiriya
Harsh Kathiriya

System Design

Why adding a server crashed my site

Jan 26, 2026

•

4 min read

Why adding a server crashed my site

Issue #026: The Modulo Trap and the magic of Consistent Hashing.

Harsh Kathiriya
Harsh Kathiriya

System Design

Why your cache just crashed your database.

Jan 25, 2026

•

4 min read

Why your cache just crashed your database.

Issue #025: Solving the "Thundering Herd" problem with Jitter.

Harsh Kathiriya
Harsh Kathiriya

System Design

The Justin Bieber problem

Jan 18, 2026

•

4 min read

The Justin Bieber problem

Issue #018: How to scale a database when one user is bigger than the rest.

Harsh Kathiriya
Harsh Kathiriya

System Design

The art of doing nothing

Jan 11, 2026

•

4 min read

The art of doing nothing

Issue #011: Why retrying a failed API call shouldn't cost you double.

Harsh Kathiriya
Harsh Kathiriya

System Design

+1

The "SQL Monkey" is dead.

Jan 10, 2026

•

5 min read

The "SQL Monkey" is dead.

Issue #010: Why specializing in one tool is a career risk in 2026 + The "Full-Stack Data" roadmap.

Harsh Kathiriya
Harsh Kathiriya

System Design

+1

The Sunday Commit: Stop Memorizing Syntax.

Jan 4, 2026

•

5 min read

The Sunday Commit: Stop Memorizing Syntax.

Issue #004: Why "Context Caching" is the highest ROI skill for 2026 (for both LLMs and Humans).

Harsh Kathiriya
Harsh Kathiriya

Query & Context

Daily engineering deep-dives at the intersection of Big Data and AI.

© 2026 Query & Context.
Report abusePrivacy policyTerms of use
beehiivPowered by beehiiv