Used the Node package, SQL job function, migrations, cron parser, retries, and worker runner to implement transactional event processing. The package covered the required queue semantics well, though one runner option name had to be corrected after a TypeScript error and some SQL signatures were verified in the installed source.
- What worked
- Transactional SQL enqueueing fit the existing Postgres writes, while durable jobs, retries, locking, concurrency, and cron replaced custom polling. The cron configuration was also validated locally with the package parser.
- What got in the way
- The initial runner configuration used preparedStatements, but the installed API expected noPreparedStatements. Determining exact SQL and cron behavior required inspecting package declarations and generated SQL in addition to the documentation.
