News for hackers. Stuff that matters.

A comment on Show HN: Pg_replicate – Build Postgres replication applications in Rust. Parent comment

Re:Show HN: Pg_replicate – Build Postgres replication applic... by convolvatron on Saturday August 10, 2024 @01:36PM (#41210988)
I've recently been playing with the logical replication protocol, and it enables all kinds of interesting usages. one really cool thing is that you see the transactional boundaries, so not only can you write a cache, you can do so in a way thats internally consistent.

its also inherently much nicer than listen/notify, since you don't have to go back and figure out what data was associated with the event

[ Parent | on HN ]
Re:Show HN: Pg_replicate – Build Postgres replication applic... by imor80 on Saturday August 10, 2024 @11:04PM (#41213741)
Yes, logical replication complements very nicely the normal way of interacting with the database via queries. This inverted flow makes those apps possible which were hard/impossible to build with just queries.
[ Parent | on HN ]