Logicaldecoding Alternatives

logicaldecoding reviews and mentions

• PostgreSQL Logical Replication Explained
  4 projects | news.ycombinator.com | 18 Mar 2023

  For C there should be good options.

  For Rust it doesn't appear that well-supported.

  A very simple approach is to poll for changes using `pg_logical_slot_get_changes()` - that should work with any driver. That's what I used for my initial experimentation, before switching over to the streaming replication protocol for better performance.

  The streaming replication protocol is not that complicated, but currently you'll have to handle some of the low-level protocol yourself, or work with some very experimental implementations. There's a project to help get you started at [1], and some more discussion at [2].

  For the logical decoder, wal2json is quite nice to experiment with, but I've found pgoutput is not that complicated and gives you something closer to the raw data.

  [1]: https://github.com/seddonm1/logicaldecoding/

  [2]: https://github.com/sfackler/rust-postgres/issues/116

• Postgres Logical Decoding Example
  1 project | /r/rust | 25 Nov 2022

  Here is a link to the code: https://github.com/seddonm1/logicaldecoding

• Show HN: Logical Replication with Rust
  3 projects | news.ycombinator.com | 24 Nov 2022
• A note from our sponsor - InfluxDB
  www.influxdata.com | 2 May 2024

  Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →