Thomas Kellerer wrote:
Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41:
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility?
Minimal research has allowed me to code something for
Firebird/Interbase, but I'm not in a position to investigate Oracle,
IBM, MS and the rest. I'd appreciate any general comments from
somebody who has broad SQL experience, I'm not asking for example
code.
For Oracle this would be the "change notification" feature which
goes beyond what Postgres can do if I'm not mistaken as you can
register a query and the client is notified if the result of that
query would change:
http://docs.oracle.com/database/121/JJDBC/dbchgnf.htm#JJDBC28815
Thanks for that, very useful. There's minimal info on the
Firebird/Interbase equivalent at
http://www.firebirdsql.org/file/documentation/papers_presentations/Power_Firebird_events.pdf
but my recollection is that it's very lightweight- no useful payload.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
