Email might never arrive, though. The only way to know they got it is to have them follow a link to confirm.
Re:Choose Postgres Queue Technology
by collinvandyck76 on Sunday September 24, 2023 @11:41PM
(#37639464)
That's kind of missing the parent's point. If you wanted to ensure emails arrive, that sounds like another queue that could be backed by a different table that is also produced into as part of the original transaction.
The big advantage is for code paths which async modify your DB; these can be done fully transactionally with exactly-once semantics since the Job consumption and DB update are in the same transaction.