File Locking And Concurrency In SQLite Version 3An EXCLUSIVE lock is needed in order to write to the database file. Only one EXCLUSIVE lock is allowed on the file and no other locks of any kind are allowed to coexist with an EXCLUSIVE lock. In order to maximize concurrency, SQLite works to minimize the amount of time that EXCLUSIVE locks are held. The operating system interface layer understands and tracks all five locking states described abov
[sqlite] getting rid of dirty SQLITE_BUSY workaround
Jon Galloway - SQLite - Database is locked
