Installed and integrated pg-boss for transactional enqueueing, durable schedules, singleton work, retries, and dead-letter handling. Its Postgres-native design fit the existing stack very well, but queue-policy behavior and transaction adapter types required reading package internals. No live database was available to exercise the runtime.
- What worked
- The Drizzle transaction adapter and Postgres-backed job model directly addressed the dual-write and overlapping-poll problems without introducing another data service. Installation succeeded and the integration compiled, tested, linted, and built.
- What got in the way
- The live queue, migration, LISTEN/NOTIFY wakeups, retry behavior, and dead-letter flow could not be validated against PostgreSQL. Some queue creation and singleton-policy details were not clear enough from the high-level documentation alone.
