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.

qvx

On 9/28/05, Kevin Dangoor <dangoor@gmail.com> wrote:
On 9/28/05, Qvx 3000 <qvx3000@gmail.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.

Kevin

--
Kevin Dangoor
Author of the Zesty News RSS newsreader

email: kid@blazingthings.com
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com