Using SQLite as a multi-user database?

[Ruslan Zasukhin]

On 11/23/10 4:15 PM, "Andre Garzia" <andre at andregarzia.com> wrote:

> Fredrik,
Hi Andre,

 
> 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.

Hmm

> 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.

Hmmmmmmm  :-)|

Fredrick says:

> Oh, and the reason I have to use SQLite is that I can't run any database
> servers (the IT department would be.... annoyed to say the least).

Once again:
     Fredrick thinks that IT department will not allow
        ANY db server.

If to make OWN "self contained server which talks to SQLite" and
    "all the clients would talk to this same server"

... then sorry?  What difference to "ANY DB Server" ?


Fredrik, 

The only ways for you are:

1) forget about multi-user access

2) take coffee with your IT guys and explain them that you NEED
    a multi-user DB server.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]