[sqlalchemy] Re: Simple transactions

2007-01-18 Thread Jonathan Ellis
On 1/17/07, Miki [EMAIL PROTECTED] wrote: # Notice we didn't commit yet This means that if someone is querying the table in the middle of the transaction it'll get wrong results. (I'm not a DB expert, this might be total nonsense) no, it just means that queries run in the same uncommitted

[sqlalchemy] Re: Simple transactions

2007-01-18 Thread Michael Bayer
just a note, when you use SQLite, by default you get the same connection every time within a single thread, since its using SingletonThreadPool. read the docs for options on how to change this. --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: Simple transactions

2007-01-18 Thread Michael Bayer
FAQ updated with this issue since its all too frequent. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this