LC and SqlLite Question

[Bob Sneidar]

As mentioned, only for reads, only one for write. But why not create a server agent that is responsible for handling multiple connections from clients, and the server agent can be the single connection to the sqLite database? 

Bob S


> On Mar 10, 2022, at 08:34 , 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