[odb-users] postgresql data change callback

[Boris Kolpackov]

MM <finjulhich at gmail.com> writes:

> If my application, while having a connection to a postgresql database,
> wishes to be notified when data in a persistent container is changed by
> another application, is there any "notify" mechanism that odb supports?

No, no such mechanism at the moment.


> If not, the advice would be to use native libpq library facilities for such
> a feature?

Correct. One potential issue that I see is that you will presumably have
to hold the connection while you are waiting for the notification, which
may not scale very well, especially in PG with its connection-per-process
model. Maybe you could dedicate one shared connection to waiting for all
the notifications or some such.