|
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 =~
|