Re: [SQL NOTIFY Help] sending NOTIFY to the external program - Mailing list pgsql-sql

From Dave Steinberg
Subject Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Date
Msg-id 459BD7DF.1030807@redterror.net
Whole thread Raw
In response to Re: [SQL NOTIFY Help] sending NOTIFY to the external program  (Andrew Sullivan <ajs@crankycanuck.ca>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Next
From: chester c young
Date:
Subject: quoted variables in pgsql