[sqlalchemy] Managing connections for undefined number of parallel processes

2011-01-31 Thread Eduardo
Dear all, My application create parallel processes that access and query a database. My problem is that I can not use engine or connection object in any of these processes because they can not be pickled (requirement for the input arguments for functions that trigger processes). Is there any way

Re: [sqlalchemy] Managing connections for undefined number of parallel processes

2011-01-31 Thread Michael Bayer
When you create a new Python process, you must create a new engine with create_engine() specifically in that process, and use that for all operations. DBAPI connections are not portable over process boundaries. As far as the number of connections, the number of connections can be managed on