Query Optimization: How to Read EXPLAIN Plans and Fix Slow Queries
A slow query in production is a fire. EXPLAIN plans show exactly where the database wastes time — if you know how to read them. This post teaches you how, with real examples.
Tech Blog · Insights & Experiments
Exploring modern web & software engineering
Deep dives into code, design, and system architecture. From frontend to backend, from performance tricks to developer experience — practical notes for building better technology.
120+ articles
20+ technologies
weekly updates
Featured
View allRelational Model & Normalization: How to Design Tables That Last
Bad schema design creates bugs invisible until production. Learn the relational model from first principles, then normalize to 3NF/BCNF with real examples and trade-offs.
What is a Database & DBMS: Why Not Just Use Files?
Most developers use databases without knowing why they exist. Learn what a DBMS really does, why flat files fail at scale, and the trade-offs that make databases essential.
Divide & Conquer: The Strategy Behind the Fastest Algorithms
Divide and conquer is behind merge sort, binary search, and fast power. Master the split-solve-merge pattern and the Master Theorem for complexity analysis in one focused post.
Recursion & Backtracking: Think in Trees, Code in Functions
Every recursive solution is secretly a tree traversal. Once you see that, pruning becomes obvious. Master the backtracking template and 4 problem types found in every interview.
Graphs: From Zero to BFS/DFS in One Post
Graphs intimidate more than any other topic — but most problems use just 4 techniques. Master BFS, DFS, topological sort, and union-find with a clear decision framework.
Latest
View all
Databases
9 min read
Distributed Transactions: Two-Phase Commit, Saga and When to Use Each
Distributed transactions are hard. 2PC gives safety at the cost of availability. Saga gives availability at the cost of complexity. This post explains both and when each is right.
Databases
9 min read
CAP Theorem and PACELC: What They Mean for Real Database Decisions
CAP theorem is misunderstood constantly. PACELC is more useful but almost unknown. This post explains both with concrete database examples and the decisions they actually inform.
Databases
9 min read
Database Partitioning and Sharding: Range, Hash and Consistent Hashing
Sharding splits data across multiple nodes and creates a new class of problems. This post covers range, hash, and consistent hashing with trade-offs that matter in production.
Databases
10 min read
Failover, Consensus and High Availability: Raft, Paxos and Automatic Failover
Automatic failover sounds simple — consensus makes it hard. This post explains leader election, Raft vs Paxos trade-offs, and what high availability means in distributed databases.
Databases
10 min read
Replication Lag and Consistency: Read-Your-Own-Writes, Monotonic Reads and More
Replication lag creates bugs that only appear under load. Read-your-own-writes, monotonic reads, and consistent prefix reads are the guarantees that prevent them.
Databases
9 min read
Database Replication: Single-Leader, Multi-Leader and Leaderless Explained
Replication keeps databases available when servers fail. Single-leader, multi-leader, and leaderless each trade consistency differently — this post explains all three clearly.
Explore by topic
View allLearn by series
View all
Completed
6 posts
Algorithm Interview 2026: Data Structures — Know Your Tools
Master the 6 data structures that appear in 80% of technical interviews. Each post goes deep on one structure — how it works under the hood, every interview pattern it unlocks, and the exact templates that win offers.
Mar 2026 – Mar 2026
View series
Completed
6 posts
Part 7 — Routing, Hooks, and Build Optimizations (Vite/Webpack)
Learn how to structure routing, master custom hooks, and optimize React builds using Vite and Webpack for production-grade apps.
Jan 2026 – Feb 2026
View series
Completed
6 posts
Part 0 — Web Fundamentals for Modern Full-Stack
Build a rock-solid foundation in HTML, CSS, JavaScript, and modern tooling to prepare for a professional full-stack journey using React, NestJS, and PostgreSQL.
Nov 2025 – Nov 2025
View series
Completed
16 posts
Frontend Design from Zero to Hero: Master the Art of Modern Web Interfaces
A complete 16-part learning journey that takes you from frontend design fundamentals to advanced professional practices. Learn HTML, CSS, responsive layouts, UI components, animations, accessibility, and design systems — all through practical, step-by-step lessons and real-world examples.
Oct 2025 – Oct 2025
View series