Comment on Postgres as queueparentComments−CubsFan10602yhttps://microservices.io/patterns/data/transactional-outbox....It allows you to wrap it all in a transaction. If you separate a database update and insertion into a queue, whichever happens second may fail, while the first succeeds.−illusive40802yTell the alternative is a saga pattern to implement a distributed two phase commit.Or actual XA, but that is cursed.
Comments
https://microservices.io/patterns/data/transactional-outbox....
It allows you to wrap it all in a transaction. If you separate a database update and insertion into a queue, whichever happens second may fail, while the first succeeds.
Tell the alternative is a saga pattern to implement a distributed two phase commit.
Or actual XA, but that is cursed.