Actually, Postgres provides a great way to subscribe to real time changes via the WAL. I even maintain an open source library for this: https://github.com/cpur

Actually, Postgres provides a great way to subscribe to real time changes via the WAL. I even maintain an open source library for this: https://github.com/cpursley/walex https://github.com/cpursley/walex