Blog

Long-form posts

Long-form writing about systems, software, and decisions that age well.

BlogPublished Sep 23, 2026

Inside Database Indexing: Postgres Heaps vs. MySQL Clustered B-Trees

Both Postgres and MySQL use B-Tree indexes, but InnoDB stores the table inside the B-Tree while Postgres keeps an unordered heap and points at it with CTIDs. A deep dive into what that difference costs you on every lookup, every UPDATE, and every UUID primary key.

PostgreSQLMySQLDatabaseIndexesB-TreeMVCCInnoDBPerformanceBackend Engineering
19 min readRead
BlogPublished Apr 16, 2026

How a Missing Index on a 20 Billion Row Table Ruined My Saturday

A real story about how a missing database index on a 20 billion row event tracking table crashed production, brought in the CTO on a Saturday, and what I learned about indexes, composite indexes, and why CREATE INDEX at the wrong moment can make everything worse.

PostgreSQLDatabasePerformanceIndexesComposite IndexesReal StoryBackend Engineering
16 min readRead
BlogPublished Apr 13, 2026

Why Your Code Keeps Breaking: The Real Meaning of SOLID Principles

SOLID isn't abstract academic theory. It's five survival tools that stop your codebase from collapsing under its own weight — explained the way nobody explained them to you the first time.

Software EngineeringSOLIDClean CodeOOPArchitectureBest Practices
12 min readRead
BlogPublished Mar 25, 2026

Nobody Talks About Maintenance. That's How Bugs Hide for 8 Years.

A developer's honest, unfiltered experience working inside an 8-year-old codebase nobody dares touch — and the lessons every developer needs to hear before they write another line of code.

Software EngineeringMaintenanceClean CodeDocumentationTechnical DebtReal Talk
11 min readRead
BlogPublished Feb 17, 2026

Is Claude Better Than ChatGPT for Writing? A Developer's Honest Take

A 4-year software developer breaks down Claude vs ChatGPT across coding, debugging, writing, cold emails, and daily dev tasks — with no fluff.

AI ToolsClaudeChatGPTDeveloper ProductivityWriting
11 min readRead