News for hackers. Stuff that matters.
Re:Choose Postgres Queue Technology by theptip on Sunday September 24, 2023 @06:37PM (#37637846)
Worth being clear that bridging to another non-idempotent system necessarily requires you to pick at-least-once or at-most-once semantics. So for emails, if you fail awaiting confirmation of your email you still need to pick between failing your transaction and potentially duplicating the email, or continuing and potentially dropping it.

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.

Re:Choose Postgres Queue Technology by skybrian on Sunday September 24, 2023 @07:09PM (#37638058)
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.