[sqlalchemy] Serializable txns not useful on sqlite because do_begin() does nothing

In testing my code for concurrency, I discovered that transactions are not properly isolated on sqlite, even with isolation_level='SERIALIZABLE'. It turns out that on the sqlite dialect, do_begin() does nothing. As a result, transactions are not isolated as expected. Dirty writes are easy to

Re: [sqlalchemy] Serializable txns not useful on sqlite because do_begin() does nothing

On Sep 18, 2010, at 6:52 PM, Randall Nortman wrote: In testing my code for concurrency, I discovered that transactions are not properly isolated on sqlite, even with isolation_level='SERIALIZABLE'. It turns out that on the sqlite dialect, do_begin() does nothing. As a result, transactions

Re: [sqlalchemy] Serializable txns not useful on sqlite because do_begin() does nothing

On Sep 18, 2010, at 6:52 PM, Randall Nortman wrote: In testing my code for concurrency, I discovered that transactions are not properly isolated on sqlite, even with isolation_level='SERIALIZABLE'. It turns out that on the sqlite dialect, do_begin() does nothing. As a result, transactions