Blog
Notes from the systems I build — migrations, mobile architecture, real-time systems and AI workflows.
Identity space wars: when two systems disagree about what things are
Everyone assumed the new file id and the legacy reference were the same number. We sampled 55 production files — 54 of them differed, and the ranges overlapped. This is the story of the eight-phase fix.
The Scenario Runner: an internal tool that became our migration's parity gate
Testing a damage-management platform means fabricating deep object graphs — and during a live migration, fabricating them identically in two systems. So we built a tool for it.
94 seconds to 1.9: ditching information_schema for pg_catalog
Our schema-mapping tool took a minute and a half to load. The fix wasn't caching or indexes — it was asking PostgreSQL the same question through a different door.
Re-platforming a 50-module Laravel monolith with zero downtime
How we moved a decade-old automotive damage platform onto a new normalized PostgreSQL schema — mirrored the writes, flipped the tables, then reversed the mirror until the legacy system became the copy.