LC and SqlLite Question
tom at makeshyft.com
Thu Mar 10 11:57:04 EST 2022
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:
More information about the use-livecode