[sqlalchemy] Concurrent updating of a field in the same row

2009-06-26 Thread Bram Avontuur
Hey, I'm using sqlalchemy-0.4.8 with mysql-5.0 on innodb tables. I'm having trouble updating 1 field in 1 row concurrently. The problem is that I can't seem to reliably update the fields. Simple example: Program 1: .. session.close() session.begin() u =

[sqlalchemy] Question about when to use connection pooling

2008-07-25 Thread Bram Avontuur
Hi, I'm currently developing a web application using TurboGears which makes use of sqlalchemy (0.4.6). Turbogears exposes a global 'session' object, which is initialised as scoped_session(sqlalchemy.orm.create_session()). E.g. each thread gets its own session object. Other web-accessible

[sqlalchemy] Re: Question about when to use connection pooling

2008-07-25 Thread Bram Avontuur
As I can see, the turbogears way of creating the session as I described above does not use a connection pool. First of all, am I right to assume this? The default way is to create a new connection to the database whenever a session object is instantiated this way? the Session usually