Push-Based Outbox Pattern with Postgres Logical Replication

1. mssql-changefeed

   1 4 14 5.7 Go

   

   The author says the outbox pattern should "always" be used.

   I agree with the goal -- one should definitely never publish an event externally before it is committed to DB! But I think using a "post-commit sequence number" is even more powerful than the outbox pattern.

   Sadly few DBs seems to supoort this well with low latency. CosmosDB has great support for a post commit low latency change feed

   A hack for mssql is here:

   https://github.com/vippsas/mssql-changefeed/blob/main/MOTIVA...

   More about this way of publishing events:

   https://github.com/vippsas/zeroeventhub

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. marmot

   2 34 1,942 6.5 Go

   A distributed SQLite replicator built on top of NATS

   

   Interesting approach, I use a very similar methodology in Marmot (https://github.com/maxpert/marmot) to do CDC for SQLite via triggers, and then these changes are published over NATS, replicated over to other nodes. So row-level replication powered by similar outbox except it uses NATS and JetStreams's quorum property to ensure reliable recovery.

4. zeroeventhub

   3 2 15 6.2 Python

   

   The author says the outbox pattern should "always" be used.

   I agree with the goal -- one should definitely never publish an event externally before it is committed to DB! But I think using a "post-commit sequence number" is even more powerful than the outbox pattern.

   Sadly few DBs seems to supoort this well with low latency. CosmosDB has great support for a post commit low latency change feed

   A hack for mssql is here:

   https://github.com/vippsas/mssql-changefeed/blob/main/MOTIVA...

   More about this way of publishing events:

   https://github.com/vippsas/zeroeventhub

5. rust-postgres

   4 14 3,575 7.9 Rust

   Native PostgreSQL driver for the Rust programming language

   

6. rust-postgres

   5 1 16 7.7 Rust

   Native PostgreSQL driver for the Rust programming language (by MaterializeInc)

   

Suggest a related project