This is more than acceptable my current project. My goal is to perhaps
use sqlobject in a python web server. I'm currently rewieving many web
frameworks/toolkits and multithreading is not very common. However, if
I choose to use multithreading I must know that sqlobject is capable of
MT. Before I was using this kind of connection setup, sqlobject was
terribly slow, so my only concern is if sqlobject would behave normally
(be fast) in MT environment. Actually, before I was using this kind of
connection setup, sqlobject was two orders of magnitude slower.
As a metter of fact I ran into turbogears and will be trying it next week or so. I loved you screencast.
On 9/28/05, Qvx 3000 <email@example.com> wrote:
> db_file = os.path.abspath('tel.db').replace(':','|')
> conn_string = 'sqlite:/' + db_file
> conn = connectionForURI(conn_string)
> conn.autoCommit = False
> conn2 = conn.transaction()
> sqlhub.threadConnection = conn2
This works fine but will have problems (at present) if your program is
multithreaded. If you're only running on one thread, no problem.
Author of the Zesty News RSS newsreader