Using SQLite as a multi-user database?

[Bob Sneidar]

Yes, mySQL is multiuser out of the box. FYI, I am pretty sure that if a user has an sqLite database open for writing, no one else can open it to write to it. Multiple users can have it open for read, but only one can write. Unless something has changed anyway. 

Bob


On Nov 23, 2010, at 11:07 AM, Jonathan Lynch wrote:

> Does MySQL work fine being used by multiple users accessing a MySQL database
> file on a shared drive? That is - not being used with a client/server
> structure.
> 
> On Tue, Nov 23, 2010 at 1:53 PM, David Beck
> <david_beck at rotundasoftware.com>wrote:
> 
>> 
>> I'd suggest pushing to use MySQL, even though some of these work arounds
>> are very clever and interesting. We had 3 people accessing a SQLite database
>> and started running into problems with locks on files. We moved to MySQL and
>> everything worked like a charm right away. Seems best to start with the tool
>> that will work and scale with you.
>> 
>> Best,
>> 
>> David Beck
>> Rotunda Software
>> 
>> 
>> _______________________________________________
>> 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
>> 
> 
> 
> 
> -- 
> Do all things with love
> _______________________________________________
> 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