Inconsistency between DB Query Results Between Threads

Using Django DB API I have two threads one that increments a counter getting stored to the database and then another thread that is reading this counter. T1(Thread 1) increments T2(Thread 2) reads I have found that if I increment and store the counter value in T1 and then if I fetch it in the sa

Re: Inconsistency between DB Query Results Between Threads

assuming I needed this on the methods that changed data but didn't realize it would make a difference on methods that do reads in other threads. Thanks, Jared 2010/4/28 Tomasz Zieliński > > > On 28 Kwi, 22:04, Jared Smith wrote: > > Using Django DB API I have two threads

update with where clause constraints?

My use case is that I'll have multiple users trying to update a set of objects and I want to make sure that any user committing a change has knowledge of the existing state. I was going to model that with a version number so an update would look like: update table set col=foo, col1=bar where id=p