Using SQLite as a multi-user database?
ruslan_zasukhin at valentina-db.com
Tue Nov 23 12:04:47 CST 2010
On 11/23/10 4:15 PM, "Andre Garzia" <andre at andregarzia.com> wrote:
> 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.
> 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).
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" ?
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.
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
[I feel the need: the need for speed]
More information about the use-livecode