Using SQLite as a multi-user database?

Bob Sneidar bobs at twft.com
Tue Nov 23 11:51:59 EST 2010


Andre. How would you que the requests? Since LiveCode is not multithreaded, what would happen if 2 clients made a request simultaneously? You still have the same problem don't you? Or is LiveCode capable somehow of communicating on multiple sockets simultaneously? 

Bob


On Nov 23, 2010, at 6:15 AM, Andre Garzia wrote:

> Fredrik,
> 
> Instead of risking problems by having concurrent queries to a single SQLite
> database, why don't you build a middleware?
> 
> From your email, I understood that the problem is that you can't install a
> server such as MySQL because the IT dept will be shouting. So why don't you
> use LiveCode to build a little self contained server which talks to SQLite,
> then all the clients would talk to this same server, this way, there's no
> concurrent access since everything passes thru the server.
> 
> If you're on LAN then it would be überquick to get the data around and you
> would not have to face multi user access to a single file resource (this is
> always troublesome).
> 
> Andre
> _______________________________________________
> 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





More information about the use-livecode mailing list