that's definitely the way to go .. -create a database_object -initialise at start up -then pass the database object to other classes as needed ...
If you want to get really fancy have a look at some ORM's ... I think there is a Python one called SQLObject? [EMAIL PROTECTED] wrote: > hey there, > i have a huge app that connects to MySQL. There are three threads that > are continually connecting and disconnecting to the db. The problem is, > if there is an error, it faults out sometimes without closing the > connection. i connect like this. > db = MySQLdb.connect(host="localhost", user="MyUser", > passwd="MyPassword", db="Stuff") > cursor=db.cursor() > > then i use the cursor.execute("SELECT yadda yadda > > my question is, is there a way i can set up a global connection so that > when the program loads, it connects once, then stays connected ? maybe > i could assign instances of the cursor ? > > please someone let me know if you have any good ideas > > sk > -- http://mail.python.org/mailman/listinfo/python-list