Comment on Postgres as queueparentComments−nostrebored2yDepends on your queue semantics, ie is it just an at least once delivery or is there an ack back to the queue service.If there is a two phase process then you just need idempotence and can safely transact with the db.−jvans2yIt doesn't matter what your queue semantics are. If it's not part of the transaction, delivery and push cannot be guaranteed to be atomic.
Comments
Depends on your queue semantics, ie is it just an at least once delivery or is there an ack back to the queue service.
If there is a two phase process then you just need idempotence and can safely transact with the db.
It doesn't matter what your queue semantics are. If it's not part of the transaction, delivery and push cannot be guaranteed to be atomic.