October archive

Psycopg at PgDay Europe

Posted by Daniele Varrazzo on October 26, 2010
Tagged as news, pgday

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

Posted by Daniele Varrazzo on October 22, 2010
Tagged as recipe

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')

Read more...