
Use half-open intervals for incremental extracts
Assign boundary events exactly once with SQLite predicates, compare 23- and 25-hour local days, and separate late-arrival completeness from interval correctness.
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.