LC and SqlLite Question

[Tom Glod]

And finally. https://sqlite.org/wal.html

On Thu, Mar 10, 2022 at 11:55 AM Tom Glod <tom at makeshyft.com> wrote:

> sorry about the double paste. :)
>
> On Thu, Mar 10, 2022 at 11:54 AM Tom Glod <tom at makeshyft.com> wrote:
>
>> For writing its only ever 1, but it can have multiple readers if you use
>> the write ahead log .....
>>
>> PRAGMA journal_mode=WAL;
>>
>> run that when creating database.never tested, but based on documentation. never
>> tested, but based on documentation.
>>
>> let me know if you test it successfully.
>>
>> On Thu, Mar 10, 2022 at 11:38 AM Paul Dupuis via use-livecode <
>> use-livecode at lists.runrev.com> wrote:
>>
>>> Can a sqlLite database file on disk be accessed by more than 1 LiveCode
>>> app at the same time?
>>>
>>> A server hosted mySql database can be accessed by any number of client
>>> LC apps at the same time as the serve side mySql does the record locking
>>> necessary, but what about a sqlLite file?
>>>
>>> Obviously, I could code up some test apps and try it, but I am hoping
>>> some one on the list definitively know for sure.
>>>
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>