PostgreSQL
The Database Migration That Locked the Table for Nine Minutes
Adding a column should be instant. Sometimes it is not, and the difference is worth knowing before you run it in production.
Rohit Bhadani
I write about why software breaks and how people figure it out. Founder of Krova Cloud, building isolated microVMs on our own hypervisor. Years of Shopify theme work and shared hosting before that. If I have not reproduced it, I do not publish it.
Debugging
What Running Hosting Infrastructure Taught Me About Debugging
Five years of keeping other people's websites online rewired how I think about failure. Mostly by making the consequences immediate.
Python
How to Read a Python Traceback Properly (Most Developers Read It Backwards)
The last line tells you what broke. The middle tells you why. Here is how to get a working hypothesis out of a traceback in about ten seconds.
Shopify
Shopify Metafields: Why Your Value Renders as Escaped JSON
You added a metafield, output it in Liquid, and got a wall of quotes and brackets. Here is what metafield_tag does and when you still need the raw value.
AI
Why Your Coding Agent Got Worse Halfway Through the Session
It was sharp for an hour and now it is contradicting itself and reintroducing bugs you already fixed. That is context degradation, and it is manageable.
Debugging
Every Bug Is a Story About a Wrong Assumption
Why I started a blog about software failure instead of software success, and what a debugging writeup should actually contain.
Databases
Finding the N+1 Queries You Do Not Know You Have
The code reads beautifully and issues four thousand queries. Here is how to detect them automatically instead of discovering them in production.
PostgreSQL
FATAL: sorry, too many clients already
Connection pooling explained through the failure it prevents, and why raising max_connections is usually the wrong fix.
Debugging
strace for Web Developers: Seeing What Your App Really Asks the Kernel
When your profiler shows nothing and your logs are silent, strace shows you every syscall with timings. Here is a practical subset worth knowing.
DevOps
Terraform Says It Will Destroy Something It Should Not
A plan showing forced replacement of a database is a good moment to stop. Here is how to read why, and the three ways state gets out of sync.
DevOps
Structured Logging, and What to Actually Put in a Log Line
Most logs are unqueryable prose written for a human who will never read them. Here is what makes a log line useful during an incident.
AI
Debugging an MCP Server When the Agent Just Goes Quiet
Your tool is registered, the agent knows it exists, and nothing happens. Here is how to see what is actually crossing the wire.