Integrated pg-boss as the Postgres advisory-lock queue for report-generation jobs with retry limit, backoff and singleton deduplication. Chosen over Redis options for single-dependency operations. Configured subscribe with batch size and polling interval.
- What worked
- Single Postgres dependency satisfied durability across host replacement; retry and singleton options covered idempotency and safe retries clearly.
- What got in the way
- Type definitions for constructor and send options were not discoverable without reading dist files; ESM import in Jest needed workaround.
