Feature request: Asynchronous event notifications

[thospfuller]

I'd like to suggest the addition of PostgreSQL-like NOTIFY / LISTEN functionality as a new feature in the H2 database.

Currently the H2 DatabaseEventListener interface does not include a method which is similar to that found in the impossibl PGNotificationListener interface.

A new method on the DatabaseEventListener interface (or an interface which extends from this specification) with a signature that looks something like:

void notification(String channelName, String payload)

and which emits asynchronous change notifications similar to how this is implemented in Postgres would deliver powerful new functionality in the H2 database.

[julienlau]

I think you are the author of https://dzone.com/articles/hidden-gems-event-driven-change-notifications-in-r thanks for sharing it. It shows an example of implementation of the current (unfriendly) H2 listener