
Separate events from periodic snapshots
Keep inventory movements separate from closing balances, check missing warehouse coverage, and reconcile state with changes under an explicit reporting boundary.
Foundation
The journal / Ideas in progress
Engineering & everyday learningSoftware, systems, and the things I’m learning along the way. From first principles to AI in production.
Find something to readA little theory. A lot of practice.

Keep inventory movements separate from closing balances, check missing warehouse coverage, and reconcile state with changes under an explicit reporting boundary.

Define what one analytical row represents, keep receipt and line measures separate, and distinguish a missing line from an observed zero with executable SQL.