Integrated Procrastinate as the PostgreSQL-backed queue, using transactional deferral, a separate worker, queues, retries, and maintenance. API and CLI introspection was needed to correct assumptions about task types and queue argument syntax.
- What worked
- It supported the key requirement that the analysis row and job enqueue commit in one PostgreSQL transaction, with a small job payload and restartable workers. Tests and CLI help completed successfully.
- What got in the way
- An expected top-level Task attribute did not exist, and the initially planned positional queue syntax was wrong; the worker required the comma-separated --queues option.
