Re: [SQL NOTIFY Help] sending NOTIFY to the external program

Поиск
Список
Период
Сортировка
От Dave Steinberg
Тема Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Дата
Msg-id 459BD7DF.1030807@redterror.net
обсуждение исходный текст
Ответ на Re: [SQL NOTIFY Help] sending NOTIFY to the external program  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-sql
> On Wed, Jan 03, 2007 at 07:47:34PM +0530, ramachandra.bhaskaram@wipro.com wrote:
>> Yes, our application is supposed to know *immediately* that a change in
>> the database has occurred since, 

I'd recommend some sort of "whiteboard" layer or messaging fabric as an 
option for this sort of thing.  This offloads the notification element 
from the database, and lets you pass along any data you want to the 
listeners - even the complete record.

Also this sort of thing scales well to multiple listeners.  Anyway, just 
a thought...

Regards,
-- 
Dave Steinberg
http://www.geekisp.com/
http://www.steinbergcomputing.com/


В списке pgsql-sql по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Следующее
От: chester c young
Дата:
Сообщение: quoted variables in pgsql