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

-- 



Reply via email to