SQLite locking: http://www.sqlite.org/lockingv3.html http://www.sqlite.org/lockingv3.html """ An EXCLUSIVE lock is needed in order to write to the database fil

SQLite locking: http://www.sqlite.org/lockingv3.html http://www.sqlite.org/lockingv3.html """ An 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. """ But compared to something like MySQL w/ InnoDB (or postgres, or Cassandra, or BerkeleyDB), which all have something closer to Row Level or Page Level locking, SQLite's concurrency for server side applications is a serious deficiency. Yes, there are lots of ways to have fine grained locking, SQLite just doesn't do them.