LC and SqlLite Question

[Tom Glod]

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
>>
>