On Jun 27, 2012, at 9:08 PM, Anthony wrote: > SQLite is a file-based database, so has to have more course locking than a > typical client/server database. Other databases have "select for update" > functionality, which allows you to select a set of records and lock them. > web2py actually supports this, via .select(..., for_update=True). >
The SQLite adapter simulates select for update by wrapping the select+update in a transaction. Not too efficient, since it has to lock the entire database, but it'll do it.
