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