[sqlalchemy] Re: transaction spanning multiple threads

2015-02-18 Thread Christian Lang
Hi Laurence, thanks for the reply. These are good pointers. Besides your suggested approach I am also trying something simpler as my use case is very specialized: 1) both Thread 1 and 2 write to completely different tables, 2) they are started both exactly after q2, 3) they (provably)

[sqlalchemy] Re: transaction spanning multiple threads

2015-02-17 Thread Laurence Rowe
I'd recommend keeping the writes to a single thread if you can as that will be easiest. If you can't do that then you could tie them together using the transaction module's two phase commit and zope.sqlalchemy. As you want the same transaction shared across threads you'll want to create your