Connection pooling and with statement

Hi,

I want to use psycopg2 in a WSGI environment. There you can have a
(configurable) number of processes and threads created that would be
accessing the database. Now I wonder what might be the best practice to
implement the pool. I don't think it is practicable to create the pool
in the WSGI application since this would create a number of pools for
each process and/or threads.

Or is the pool class simply not suitable for such a task?

Another question that occured to me is how I use the with statement with
the pool class:

I can do:
with pool.getconn() as conn:
     with conn.cursor() as cursor:
         # do stuff

Where do I need to call pool.putconn(conn)? How does the with statement
affect the connection? Is the with statement suitable for connection
pooling at all?

Many thanks,

Frank


--
Frank BRONIEWSKI

METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN

tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.metrico.lu