Thread: Listen/notify, equivalents on other DBs
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. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues]
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
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]