Blog
5
Long-form writing about systems, software, and decisions that age well.
Latest: Inside Database Indexing: Postgres Heaps vs. MySQL Clustered B-Trees
Vivek Chauhan
Long-form blogs and personal updates.
A personal publishing website focused on clarity, good reading rhythm, and simple architecture that stays maintainable over time.
Featured
Latest blog post
The newest long-form piece from the blog collection.
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
Recent
Latest blog posts
Fresh writing from the main blog collection.
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
Topics
Tag stream
Recurring ideas across blog posts.
AI ToolsArchitectureB-TreeBackend EngineeringBest PracticesChatGPTClaudeClean CodeComposite IndexesDatabaseDeveloper ProductivityDocumentation
Quick links
Site sections
Primary writing collections.