Push-Based Outbox Pattern with Postgres Logical Replication

1. mssql-changefeed

   1 5 21 6.2 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. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. marmot

   2 34 2,047 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 18 6.8 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,770 7.8 Rust

   Native PostgreSQL driver for the Rust programming language

   

6. rust-postgres

   5 1 20 5.6 Rust

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

   

7. Sevalla

   sevalla.com featured

   Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!

   

Suggest a related project