Latest articles

PostgreSQL notifications with Psycopg2 and Eventlet

PostgreSQL supports asynchronous notifications, a simple messaging system allowing clients to be notified about events occurred in the database. Notifications can be sent by any session using a "NOTIFY channel" command and will be received by any session which has subscribed with a LISTEN channel to receive updates. The system has been greatly improved in PostgreSQL 9.0 with the addition of a message payload, making the feature even more useful. Previously a typical use case would have been to notify interested sessions that a certain table was updated: now it is possible to signal for instance which record was changed. You can put the NOTIFY command in a database trigger for automatic notifications on insert or update... the possibilities are actually quite interesting.

Psycopg 2.3.0 released

Hi *,

lately my involvement on psycopg has been quite small (work and other projects are taking their toll) but thanks to Daniele (with some help from Jan) here is a new psycopg2 release. The number of changes is big (an excerpt from the NEWS file is at the end, as always) so we decided to bump up the version to 2.3.0 and to test, and test... and test. We tested this new release on Linux and Windows, with Python 2.4, 2.5, 2.6, 2.7 and on PostgreSQL from 7.4 to 9.0.

Psycopg at PGDay Italy 2010

Psycopg will be at PGDay Italy in Rome, on December 10th.

Links about building Psycopg on Mac OS X

Looks like building Psycopg on OS X is tricky: the code needs no tweak, but linking against the right library seems problematic.

Psycopg 2.3.0-beta1 released

We have just released a new testing package: psycopg 2.3.0-beta1!

New features in the upcoming Psycopg release

There are several new features being prepared in the upcoming Psycopg version. The documentation refers to it as release 2.2.3 but it may be ultimately released as 2.3. The main target of the release is to expose some of the new features introduced in PostgreSQL 9.0.

Psycopg at PgDay Europe

Hello,

I will be at PgDay Europe 2010 in Stuttgart with a talk about Psycopg: Advanced PostgreSQL Access from Python with Psycopg.

The talk will be about some of the most advanced functionalities and new features available in the latest Psycopg releases: asynchronous communication, notifications, server-side cursors, advanced data mapping between Python and PostgreSQL, the upcoming support for two-phase commit and hstore objects.

If you have any suggestion about what you'd like to be shown in the talk, you may leave a feedback.

See you in Stuttgart!

Passing connections to functions using a decorator

In many script I write, there are functions requiring database operations. Every time I need them, I try to write such code in functions like:

@with_connection
def do_some_job(cnn, arg1, arg2=None):
    cur = cnn.cursor()
    cur.execute(SQL, (arg1, arg2)) # or something else

do_some_job(42, arg2='hi')

Psycopg 2.2.2 released

Hi *,

summer release! Just bugfixes, this time. Get it from:

Psycopg 2.2.1 released

Hi *,

repeat with me:

for x in xrange(1000):
    print "Always check it build on windows!"

but thank to Jason Erickson here is 2.2.1 that DO build on windows. :) No excerpt this time, it's a single liner, but here are the URLs:

Have fun,

federico

« Previous | 6 | Next »

psycopg

Latest articles

PostgreSQL notifications with Psycopg2 and Eventlet

Psycopg 2.3.0 released

Psycopg at PGDay Italy 2010

Links about building Psycopg on Mac OS X

Psycopg 2.3.0-beta1 released

New features in the upcoming Psycopg release

Psycopg at PgDay Europe

Passing connections to functions using a decorator

Psycopg 2.2.2 released

Psycopg 2.2.1 released

Psycopg 3

Psycopg 2

Mailing List

Articles archive