Relational 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.
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 allWhat 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.
Trees & Binary Search Trees: The Interview Favorite
Trees are the most-tested structure in FAANG interviews. Master DFS, BFS, all traversals, LCA, path sums, and BST validation with a recursive framework that makes it click.
Latest
View all
Databases
10 min read
Database Indexes: B-Tree, Hash, Composite — When and Why to Use Them
Indexes are the biggest lever for database performance — and the most misused. Learn how B-Tree and Hash indexes work, when to add them, and when they hurt more than help.
Databases
11 min read
SQL Fundamentals: SELECT, JOIN, GROUP BY and the Queries That Trip Everyone Up
SQL is easy to start and hard to master. This post covers every JOIN type, GROUP BY traps, subqueries, and the mental model that makes complex queries feel obvious.
Databases
10 min read
Relational 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.
Databases
10 min read
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.
Career & Skills
12 min read
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.
Career & Skills
11 min read
Greedy Algorithms: When Being Selfish Gives the Optimal Answer
Greedy algorithms are easy to implement but hard to justify. Learn the exchange argument, the 5 greedy patterns, and when greedy fails so you know to reach for DP instead.
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