Notes from the field.
Incidents, architecture, and what AI agents do to my workflow. RSS.
-
When indexing isn't enough: a 4.2M-row deadlock fix
A composite index that reduced a full-scan from 4.2M to 34 rows, and the query rewrite that made the index usable.
-
Offline-first sync for field operations under intermittent connectivity
Architecture and design decisions for a field app that has to stay functional through full connectivity, low signal and complete offline periods.