Using SQLite as a multi-user database?
fredrik at morbug.se
Tue Nov 23 12:51:38 CST 2010
Björnke von Gierke skrev 2010-11-23 19.24:
> I think fredrik just uses installed programs and a sqlite file on a network share. Which is a smart way to circumvent "no server" rules, and sqlite seems to be able to do that.
Yep, that's how I planned it. Previously I've mostly used text files to
hold data, but it becomes a bit tricky when you've got several users
that might write to the data at the same time (= lots of text files +
some code to try to prevent it in order to minimize the risk). I've
managed to work around it so far but I hope this will be a better
solution in the end.
> As for rev not being able to react to multiple clients on sockets, that is not how it works. if you do not use blocking wait, and/or have huge and long calculations, everything should work, for quite a few clients.
> the most chatrev-clients ever where about 25 (over the internet, not a private network), and it didn't even slow down at all, running from a 400 mhz pentium II with 700 mb (or similar) of ram.
> I'd guess you can go into the low hundreds before needing to do special things, as long as everyone can be served within a few milliseconds or so.
> On 23 Nov 2010, at 19:04, Ruslan Zasukhin wrote:
>>> 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.
More information about the use-livecode