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