Polling publisher
Last updated
Last updated
You have applied the [[Transactional Outbox]] pattern.
How to publish messages/events into the outbox in the database to the message broker?
Publish messages by polling the database's outbox table.
implements polling.
This pattern has the following benefits:
Works with any SQL database
This pattern has the following drawbacks:
Tricky to publish events in order
Not all NoSQL databases support this pattern
The [[Transactional Outbox]] pattern creates the need for this pattern.
The [[Transaction log tailing]] pattern is an alternative solution
My book describes this pattern in a lot more detail.
The implements this pattern