Why the database ignores your index, and other indexing traps
7 min read How query planners actually decide whether to use an index, and the indexing questions that separate strong engineers in interviews. Read article
7 min read How query planners actually decide whether to use an index, and the indexing questions that separate strong engineers in interviews. Read article
6 min read The four ANSI isolation levels, what each one actually prevents, and the concurrency bugs that survive even at repeatable read. Read article
7 min read A walkthrough of the real design decisions behind approximate nearest neighbor search, from choosing HNSW or IVF to sharding and filtering at scale. Read article
6 min read What separates a passing RAG design answer from a hand-wavy one, stage by stage. Read article
6 min read Cognition’s engineering loop, the agent-infrastructure problems they put in front of you, and how to prepare for a team building autonomous coding agents. Read article
7 min read A round-by-round look at the Stripe engineering loop, where integration, debugging, and API design weigh more than algorithm puzzles. Read article
7 min read A reference grid of the thirty components that turn up in nearly every system design interview, what each one does, and where it breaks. Read article
7 min read A walkthrough of Decagon’s engineering loop, from the agent-flavored coding round to the system design and eval questions that decide it. Read article
6 min read A working engineer’s take on ByteByteGo, Grokking, Hello Interview, and DesignGurus, and which one helps depending on how you tend to fail. Read article
7 min read A walk through the CUDA performance questions, GPU parallelism design problems, and C++ rounds that show up in NVIDIA’s technical loop. Read article
7 min read A round-by-round look at Modal Labs’ interview for backend and infrastructure roles, and the kinds of questions they actually ask. Read article
7 min read A walk through Together AI’s engineering loop, from the coding rounds to GPU-serving system design and the CUDA-flavored take-homes. Read article
5 min read Design a recommendation engine like Netflix’s, Spotify’s Discover Weekly, or Amazon’s “Customers also bought.” Recommendation systems are one of the Read article
6 min read Design an LLM inference API — the service that accepts user prompts and returns model completions, like the OpenAI API, Read article
6 min read Design a monitoring and alerting system like Datadog, Prometheus + Grafana, or New Relic. This is a system design problem Read article
What's missing, wrong, or worth adding? One line helps.
Sent — thank you. We read every one.