Re: How to get a signal from the database when a INSERT INTO is done?

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: Andre Lopes <lopes80andre(at)gmail(dot)com>, postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get a signal from the database when a INSERT INTO is done?
Date: 2012-02-28 15:45:08
Message-ID: CABRT9RAm+dc7YkuJFrnKh7VJJVZ=oCG22k-iiZ7d2wgdvmHgZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 28, 2012 at 17:41, Daniele Varrazzo
<daniele(dot)varrazzo(at)gmail(dot)com> wrote:
> On Tue, Feb 28, 2012 at 2:15 PM, Marti Raudsepp <marti(at)juffo(dot)org> wrote:
>> On the Python end, you have to call psycopg2 connection.poll() method
>> periodically or in response to select() activation
>> There's an example here:
>> http://initd.org/psycopg/docs/advanced.html#async-notify

> Using an asynchronous IO-driven framework such as eventlet or gevent
> you don't even need to poll the connection to look for events

As mentioned above and as demonstrated in the example, select() also
does the job. Using such a fancy framework is usually an overkill.

Regards,
Marti

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniele Varrazzo 2012-02-28 15:54:57 Re: How to get a signal from the database when a INSERT INTO is done?
Previous Message Daniele Varrazzo 2012-02-28 15:41:56 Re: How to get a signal from the database when a INSERT INTO is done?