From: Dave Steinberg <dave-pgsql@redterror.net>
To: ramachandra.bhaskaram@wipro.com
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Date: Wed, 03 Jan 2007 11:20:47 -0500
Message-ID: <459BD7DF.1030807@redterror.net> (raw)
In-Reply-To: <20070103161021.GA8599@phlogiston.dyndns.org>
References: <47230CE166B64744B0120173E4C2161E0103E6A1@BLR-EC-MBX01.wipro.com>
<20070103161021.GA8599@phlogiston.dyndns.org>
> 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dave-pgsql@redterror.net, ramachandra.bhaskaram@wipro.com
Subject: Re: [SQL NOTIFY Help] sending NOTIFY to the external program
In-Reply-To: <459BD7DF.1030807@redterror.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox