Chris Jackson
christopher.jackson at gmail.com
Wed Feb 9 18:57:40 EST 2005
What is the best way, or at least some way to create a single database connection object in mod_python and have everyone who connects use that same DB connection. Note: I'm using the publisher handler. DB | DBconn object / | \ user user user My original theory (tested, doesn't work -- Multiple DB Connections are made): To create a global DBconn object and have each session rely on the same global variable. The idea fails I think because multiple interpreters are created with each apache child process, and so global variables are re-instantiated. New theory(untested): Make the DBconn object outside in a separate module so that python only imports the module once, hence using only a single DBconn object. In this case module space is consistent even with multiple interpreters. Any comments and/or solutions would be gladly appreciated. Thanks, ~= Chris =~
|