Re: [sqlite] All transactions are Database locks?

> Are all transactions database locks (not table locks)? Yes. > If I prepare a select statement and start stepping on Table A on process one > and pause before finializing and do an update on Table B with process two or > even the same process I will get a database is locked error? Yes. > Does

Re: [sqlite] All transactions are Database locks?

Hello Matt, Matt Froncek wrote: Are all transactions database locks (not table locks)? Sqlite doesn't support table or row level locking. Locking is implemented via file locks. Hence if you separate your table space into different databases and use the ATTACH keyword, you can effectively ge

[sqlite] All transactions are Database locks?

Are all transactions database locks (not table locks)? If I prepare a select statement and start stepping on Table A on process one and pause before finializing and do an update on Table B with process two or even the same process I will get a database is locked error? Do I understand that this is