Simultaneous access to same SQLite database from separate stacks?

[Robert Sneidar]

Just a warning. Our original electronic key system used an access database. They claimed it was "multi-user". Well, it was as multi-user as access. Which is to say it sucked. We corrupted data so many times just using it from 3 or 4 workstations that we eventually upgraded to the enterprise system at a discount because they felt so bad for selling us that can of worms. (Vendor names duly avoided). 

What's the point you say? Only use products designed to be multiuser from the ground up, at least if you are developing a commercial product. 

Bob


On Nov 9, 2012, at 4:29 AM, Dr. Hawkins wrote:

> On Thursday, November 8, 2012, Peter Haworth wrote:
> 
>> Yes, but keep in mind that the whole database is locked for the duration of
>> the transaction so if you have a long operation going on by one user, your
>> other users will have to wait a while.
> 
> 
> That should be livable, I think.