Psycopg and prepared SQL statements

From: Nicolas Boullis <postgresql(at)ilcode(dot)fr>
To: psycopg(at)postgresql(dot)org
Subject: Psycopg and prepared SQL statements
Date: 2014-05-16 12:22:22
Message-ID: 20140516122222.GA5010@tryphon.debian.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: psycopg

Hi,

Lately, I’ve been designing and writing a WSGI webapp for which
performance matters. This webapp queries a PostgreSQL database.

As performance matters, I am using a ThreadedConnectionPool from
psycopg2.pool, but I also want to have my SQL statements prepared.

I read
http://initd.org/psycopg/articles/2012/10/01/prepared-statements-psycopg/
but I could not find a way to mix PreparingCursor with the connection
pool.
Each statement should definitely be prepared only once for each
connection, and I could not find a way to attach the prepared cursors to
the connections in the pool.

So i designed a class that wraps SQL statements, and a class whose
instances are connection factories that prepare the needed statements.

Here is the result of my work, wit a simple example.

All comments are welcome. I think it woul be nice if psycopg could offer
a way to use prepared statements.

Cheers,

--
Nicolas Boullis

Attachment Content-Type Size
prepared_statements.py text/x-python 1.6 KB

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2014-05-16 12:25:14 Re: Psycopg and prepared SQL statements
Previous Message Daniele Varrazzo 2014-05-13 17:13:54 Psycopg 2.5.3 released