I found my self always doing some kind of polling loop for my applications when i want to watch data as it comes in, however i find striking the balance between aggressive polling and the responsiveness tricky.
So i wrote (with help from claude) pgnudg. pgnudge is a small async Python library that wakes your app when specific Postgres tables change. It only tells you which tables moved. You refetch, and the database stays the source of truth.It reads the WAL over the replication protocol and turns commits into per-table wakeup
I am more than willing to acknowledge that this is properly overkill, but I found it interesting, and maybe some else might as well?