News for hackers. Stuff that matters.
Re: by foota on Thursday July 10, 2025 @06:28PM (#44526402)
Wouldn't you need to then commit to remove the entries from the temp table?
Re: by zbentley on Thursday July 10, 2025 @06:33PM (#44526437)
No, so long as the rows in there are transactionally guaranteed to be present or not, a sweeper script can handle removing failed “publishes” (notifys that didn’t delete their row) later.

This does sacrifice ordering and increases the risk of duplicates in the message stream, though.