Re: [sqlite] Locking in sqlite

So if A, B and C are different files then they will not block despite leaving inside the same connection, right? BTW, by "block" I mean retrying after SQLITE_BUSY too. That's very good and convenient thing. Thank you, Pavel On Sat, May 2, 2009 at 10:05 PM, Nuno Lucas wrote: >

Re: [sqlite] Locking in sqlite

On Sat, May 2, 2009 at 3:48 PM, Pavel Ivanov wrote: [...] > update main.t set x = 1 > update B.t set x = 1 > update C.t set x = 1 > > My question is will these statements be able to execute in connections > in parallel simultaneously because they use different databases and >

[sqlite] Locking in sqlite

Hi, all! I wasn't able to find clear answer to my question about locking in sqlite in documentation, so please help me who knows things well. Let's say we have 3 different connections, all created with the same pattern: connect to database A, attach database B, attach database C. Then in these 3