logicaldecoding

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/

Postgres Logical Replication (the ability to listen to the write-ahead-log) is an extremely useful tool that opens up a lot of use cases which has been put to great effect by companies like Materialize[0] and Redhat with Debezium[1]. Recently there was a discussion here on 'push-based output patterns'[2] where I saw it was not immediately obvious how to implement this pattern with existing tooling. This project seeks to demonstrate how to implement logical replication using Rust that can be easily set up and experimented with. [0] https://materialize.com/ [1] https://debezium.io/ [2] https://news.ycombinator.com/item?id=33370649