A basic PostgreSQL NOTIFY to WebSocket sample application.
The key was to use the PGJDBC-NG driver, instead of the regular JDBC driver, as it supports asynchronous notifications.
You can double-click the JAR to run this server. You may need to setup the following O/S environment variables:
PGPASSWORD (no default)
PGHOST (defaults to localhost)
PGPORT (defaults to 5432)
PGDATABASE (defaults to postgres)
PGUSER (defaults to postgres)
Then open your browser to http://localhost:9876 and follow the instructions.
Todo:
- use embedded jetty or tomcat so can just run as a jar (spring boot)
- allow user to indicate which channels wants to listen to in browser