Обсуждение: Re: [GENERAL] LISTEN/NOTIFY
=?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cbraga@bsi.com.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? I suggest moving any followups to pgsql-interfaces, where this discussion would be more on-topic. regards, tom lane
On Fri, 4 Oct 2002, Tom Lane wrote: > =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cbraga@bsi.com.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". See this: http://archives.postgresql.org/pgsql-interfaces/2002-01/msg00018.php > 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. -alex
alex@pilosoft.com writes: > See this: > http://archives.postgresql.org/pgsql-interfaces/2002-01/msg00018.php Ah, I'd forgotten about that. Did it get accepted into DBD::Pg? regards, tom lane