Yes, but keep in mind that the whole database is locked for the duration of
the transaction so if you have a long operation going on by one user, your
other users will have to wait a while.  This includes readers will some
sort of write operation is going on.  There is a newer type of locking
called WAL (write ahead locking) that does permit reads while write
operations are in progress but the version of the sqlite library in LC is
too old to have that available.

Pete
lcSQL Software <http://www.lcsql.com>



On Thu, Nov 8, 2012 at 6:51 PM, Dr. Hawkins <[email protected]> wrote:

> If I use locking, can I safely access the same SQLite database from two
> different standalone simultaneously?
>
> --
> Richard E. Hawkins, Esq.
> (702) 508-8462
> _______________________________________________
> use-livecode mailing list
> [email protected]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to