4+ day, 12+ hour ago   (361+ words) The correlation I eventually found was location. Users far enough east of me saw it. Users near my own timezone didn't. I spent the first stretch of debugging looking at the generation job itself — timing the cron trigger, checking for…...

5+ day, 13+ hour ago   (797+ words) The reconciliation had been off by a handful of records every day for months, and every month somebody adjusted it by hand and moved on. It was only when the discrepancy jumped after a clock change that anyone looked properly,…...

1+ week, 2+ day ago   (118+ words) Only 2 seconds passed in real life. Yet the SQL engine says: "1 day difference." Why? Because this is NOT a bug. It is 100% by architectural design. Here is the deep relational engine truth that trips up data engineers in production pipelines....

2+ week, 1+ day ago   (815+ words) There’s a funny (and slightly sad) story behind why I built mabims.dev. It started with a date. More specifically, a Hijri date. For a long time, Indonesia’s Ministry of Religious Affairs (Kemenag) website displayed the current Hijri date. You…...

2+ week, 2+ day ago   (646+ words) Short answer: treat local calendar time as schedule data, store the next due instant in UTC, and let a short dispatcher feed a rate-limited worker pool. For an edtech reminder service serving US and EU users, this keeps daily and…...

3+ week, 3+ day ago   (573+ words) Every so often a mathy essay climbs the ladder by saying something that feels almost too obvious once said out loud: humans think in whole rotations more naturally than they think in π. Turns versus radians is one of those…...

3+ week, 3+ day ago   (750+ words) A tiny, immutable date toolkit where every calendar operation resolves through a real IANA zone — and the zone data comes from the browser you are already running in. There is a bug that shows up in almost every app that…...

4+ week, 1+ day ago   (343+ words) Both indicators were right, and the hour between them was the bug. It just took a while to see how a session could be finished and not finished at the same time. The extension wasn't frozen, and it wasn't empty....