From: Jeff Davis <list-pgsql-general@empires.org>
To: Cristóvão Dalla Costa <cbraga@bsi.com.br>
To: pgsql-general@postgresql.org
Subject: Re: LISTEN/NOTIFY
Date: Fri, 4 Oct 2002 15:00:44 -0700
Message-ID: <200210041500.44980.list-pgsql-general@empires.org> (raw)
In-Reply-To: <3D9DFEF3.6020509@bsi.com.br>
References: <3D9DFEF3.6020509@bsi.com.br>
I did something similar using python with a simple "getnotify()" function
(part of the python pg module).
I couldn't find a similar function for perl -- strange.
I think the listening process needs to be a separate process anyway, since I
wouldn't think that an apache process would easily be able to wait for a
notification.
You could just do the cache invalidation process in another language, like
python or C, and all that would do is listen for an update, read the updated
info, and replace the cache. It should be small enough that you don't mind
straying from perl, hopefully.
Of course it is weird that perl doesn't support that. Maybe I missed something
too.
Regards,
Jeff Davis
On Friday 04 October 2002 01:49 pm, Cristóvão Dalla Costa wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
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: list-pgsql-general@empires.org, cbraga@bsi.com.br, pgsql-general@postgresql.org
Subject: Re: LISTEN/NOTIFY
In-Reply-To: <200210041500.44980.list-pgsql-general@empires.org>
* 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