3 ms·
Surprised to not see any mention of Postgres native pub/sub messaging: https://vijayg.com/postgresql-pubsub/ https://vijayg.com/postgresql-pubsub/ Is that feat
by ForHackernews 5y ago
Surprised to not see any mention of Postgres native pub/sub messaging: https://vijayg.com/postgresql-pubsub/ https://vijayg.com/postgresql-pubsub/
Is that feature considered well-known? Or is it so obscure this author didn't know about it?
- filomeno 5y agoI read that blog post but I don't quite understand it. I assumed it would work as a regular pub/sub pattern where you get notified when some event happens. However, in the attached example, they still poll the database every half second. I'm not sure I understand the idea.
- ForHackernews 5y agoIt's maybe not a great post, it was just one that came up when I searched. > JDBC driver cannot receive asynchronous notifications. Maybe their example is limited by the choice of client library. This might be a better example? https://tapoueh.org/blog/2018/07/postgresql-listen-notify/ https://tapoueh.org/blog/2018/07/postgresql-listen-notify/ Or the offical postgres docs are: https://www.postgresql.org/docs/14/sql-notify.html https://www.postgresql.org/docs/14/sql-notify.html https://www.postgresql.org/docs/14/sql-listen.html https://www.postgresql.org/docs/14/sql-listen.html https://www.postgresql.org/docs/14/libpq-notify.html https://www.postgresql.org/docs/14/libpq-notify.html
- filomeno 5y agoThanks, it now makes sense. Quite strange that this specific driver didn't support asynchronous notifications: if you have to poll the database anyway, there's no much difference between doing it without listen/notify support, I guess.