Batching a PostgreSQL Preview: 500 Statements to One
How PostgreSQL arrays and ordinality preserved original positions in a stored-row preview.
A Git Merge Rule for Append-Only AI Changelogs
How a scoped .gitattributes rule keeps ledger-style changelogs from turning harmless appends into manual conflicts.
The “Cheaper” LLM That Cost Four Times as Much
I swapped Opus for a budget model to cut costs. It crashed twice, ran ten times slower, and the bill went up, for reasons that never show up on a pricing page.
The Acceptance Test That Failed Before the Feature Existed
Two requirements I wrote myself, weeks apart, that could never both hold on a busy market day.
Depth, not breadth: what a stock-pattern library taught me about systems
I spent a few months building a library of a particular kind of event in the stock market — the rare cases where a small company’s shares run up several hundred percent in a short window and then collapse. Not to trade them in the moment; I’d given up on that for reasons I’ll get […]
From Behavioral Science to Software: How Psychology Shapes the Products I Build
Most people don’t think of behavioral science and software development as related fields. But after spending years studying how people make decisions, form habits, and respond to their environments, I’ve found that the principles of behavioral science are some of the most powerful tools a product builder can have. My academic background in behavioral science […]