From: Cristóvão Dalla Costa <cbraga@bsi.com.br>
To: pgsql-general@postgresql.org
Subject: LISTEN/NOTIFY
Date: Fri, 04 Oct 2002 17:49:55 -0300
Message-ID: <3D9DFEF3.6020509@bsi.com.br> (raw)
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". Also, I don't really like the vanilla Pg. So, my question
to you is, is there another efficient way to accomplish notification of
updates?
Thank you
Cristóvão
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-interfaces@postgresql.org
Cc: cbraga@bsi.com.br, pgsql-general@postgresql.org
Subject: Re: LISTEN/NOTIFY
In-Reply-To: <3D9DFEF3.6020509@bsi.com.br>
* 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