Progress on Effectum is coming along as I find a couple hours here and there to work on it. Job heartbeat and checkpoint functionality is written. Next up will be some thought about ergonomic ways to start workers that can run multiple types of tasks. I may do something inspired by the job registry in sqlxmq.
- Haki Benita wrote a short article about writing SQL in a future-proof way by adding exhaustive checking to CASE statements. This way if an unexpected new value is added to a column, a query will throw an error instead of just ignoring it.