Comment by dirkt
5 years ago
What are the options to use Postgres pub/sub with Java? Because the usual Java libraries don't seem to support the pub/sub functionality well, you have to actively poll when you want to subscribe.
5 years ago
What are the options to use Postgres pub/sub with Java? Because the usual Java libraries don't seem to support the pub/sub functionality well, you have to actively poll when you want to subscribe.
https://impossibl.github.io/pgjdbc-ng/docs/0.8.9/user-guide/...
or
https://github.com/pgjdbc/r2dbc-postgresql#listennotify
This may depend on the JDBC driver support Listen/Notify. Though if queue traffic is relatively steady then maybe polling isn't so bad?