Implemented the durable job table, idempotent enqueue, atomic claim with row locking on Postgres, backoff retries, terminal failure, and progress updates.
- What worked
- Transactions, unique constraints, and indexed claim queries expressed the queue semantics directly in the database.
- What got in the way
- Locking and datetime behavior differed between test and production databases, requiring dialect-aware claim and comparison logic.