Psycopg and prepared SQL statements

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