On Fri, 4 Oct 2002, Tom Lane wrote:
> =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cbraga(at)bsi(dot)com(dot)br> writes:
> > I'm developing an e-commerce site using Apache/mod_perl and, for
> > performance, I intend to cache rows such as user and product information
> > inside Perl. I think the LISTEN/NOTIFY interface would be perfect for
> > invalidating the cache when a product/user gets updated, yet I have not
> > found a way to access it from Perl -- DBI, or DBD::Pg even, offer no way
> > to "listen".
> I don't know what the DBI/DBD design philosophy is regarding
> database-specific extensions --- but it would seem reasonable to me for
> DBD::Pg to offer some way to get at LISTEN functionality. Can anyone
> suggest how to do this in the context of DBI?
It uses generic func() interface...
> I suggest moving any followups to pgsql-interfaces, where this
> discussion would be more on-topic.
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2002-10-06 01:08:28|
|Subject: Re: [INTERFACES] LISTEN/NOTIFY |
|Previous:||From: victor3.lopes||Date: 2002-10-05 21:31:40|
|Subject: interface PERL and return results|
pgsql-general by date
|Next:||From: Tom Lane||Date: 2002-10-06 00:39:39|
|Subject: Re: Server locale? |
|Previous:||From: Martin Weinberg||Date: 2002-10-05 23:05:36|
|Subject: Re: multi-column btree index for real values |