| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Cristóvão Dalla Costa <cbraga(at)bsi(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: LISTEN/NOTIFY |
| Date: | 2002-10-05 02:54:02 |
| Message-ID: | 264.1033786442@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
=?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?
I suggest moving any followups to pgsql-interfaces, where this
discussion would be more on-topic.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2002-10-05 02:54:52 | Re: Boolean output format |
| Previous Message | Doug McNaught | 2002-10-05 02:21:01 | Re: Boolean output format |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 2002-10-05 21:31:40 | interface PERL and return results | |
| Previous Message | Jeff Davis | 2002-10-04 22:00:44 | Re: LISTEN/NOTIFY |