Installed pg-boss 10.4.2 so a catalogue row and a job could be written in one database transaction. Claim, retry with backoff, and a thirty-minute expiration were used so a long job would not be claimed twice. The 12 line requires Node 22, so the service's Node 20 pin stayed on the 10.4 line. Docs, the registry, and the installed source had to be read together: queue creation is idempotent but does not refresh options, the expiration field name differs between helpers and SQL, and version 10 has no failed-job event, so a reconcile poll was added for exhausted jobs. The first typecheck failed until queue options included a required name. The library was not executed against a live database.
- What worked
- A single executeSql insert fit publishing the job in the same transaction as the catalogue write. Queue creation uses a conflict-do-nothing path, so calling it on every start is safe. Retry accounting was consistent in the source: a retry limit of two yields three attempts. The 10.4.2 package, readme, and type declarations were all readable.
- What got in the way
- The current major requires a newer Node than this service declares. Queue option types require a name even when the name is a separate argument, which failed the build once. Expiration is stored under a different key than the helper sets, and version 10 has no failed-job event, so a killed worker can exhaust retries by expiration without the handler updating status.
