Re:SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a...
by Mavvie on Tuesday April 11, 2023 @09:14PM
(#35533855)
That is the simple, but unreliable way to fix the issue. If your python process crashes or is killed between sending the commit and enqueueing the job, the job will never be enqueued.
A possible solution to this is to use a "transactional outbox" pattern, but that has many of the same drawbacks of using postgres as a queue.
A possible solution to this is to use a "transactional outbox" pattern, but that has many of the same drawbacks of using postgres as a queue.