Using SQLite as a multi-user database?

[Andre Garzia]

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