On Wed, Jun 20, 2012 at 9:06 PM, Anthony <abasta...@gmail.com> wrote: >> Sooo.... Have I misunderstood the SQLite locking description? > > > I believe so. The shared lock does not last forever -- only as long as it > takes to execute the select. Once the data have been read, the shared lock > (for that particular select) is released.
Yes, if autocommit is on. The part you didn't quote was that autocommit can be disabled in which case a SHARED lock is held. Since the documentation about what the DAL uses/needs/assumes about the underlying Python layer (pysqlite in this case) isn't there, its just easier to avoid using it outside of a Web2py application. Thanks for all the help, -Doug --