Post

🚨 New Blog Post 🚨 I just finished this monster of a blog post! How to listen to database changes through the Postgres WAL! This is all @filipecabaco.com's fault who nerd-sniped me into low-level Postgres details! Click here to suffer too: peterullrich.com/listen-to-da... #ElixirLang #Postgres

peterullrich.comListen to Database Changes through the Postgres WALAn in-depth guide to listening to Postgres database changes through the WAL. Covers logical replication, publications, replication slots, and an Elixir implementation.

Jaeyson Anthony Y. ⚗️

@jaeyson.dev

5 Nov 2025

Noice article 👌🏽. I remembered this library from getting db changes, although it has nothing to do with ?wal? nor ?pg_notify? github.com/cheerfulstoi...

github.comGitHub - cheerfulstoic/ecto_watch: EctoWatch allows you to easily get notifications about database changes directly from PostgreSQL.EctoWatch allows you to easily get notifications about database changes directly from PostgreSQL. - cheerfulstoic/ecto_watch

Peter Ullrich

@peterullrich.com

Yep, it uses pg_notify with a trigger which is fine for low-throughput databases: github.com/cheerfulstoi...

github.comecto_watch/lib/ecto_watch/watcher_server.ex at c2f9fd97a9c0d921ab627612c6f71cafaf2a3035 · cheerfulstoic/ecto_watchEctoWatch allows you to easily get notifications about database changes directly from PostgreSQL. - cheerfulstoic/ecto_watch

5/11/25, 2:18 pm0 reposts1 like

No replies yet.