Re: [sqlite] concurrent users?

2008-10-09 Thread John Stanton
Sqlite works well as the DBMS core of a WWW server. It is not a competitor for Oracle. DB2 or PostGreSQL but can support a large number of users and has the advantage of being embedded. It is not a good idea to use it for a large number of concurrent long queries. Sqlite works best with

Re: [sqlite] concurrent users?

2008-10-07 Thread Olaf Schmidt
"Shawn Anderson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > I've read many things, some conflicting, about concurrent > users on a Sqlite database. > The feeling I get is that Sqlite is good for a standalone desktop > database, but should not be used in a concurrent user

Re: [sqlite] concurrent users?

2008-10-07 Thread Daniel Önnerby
I'm using SQLite in a commercial application where the db is used as a document, often located at a network share (windows only). The db is used as a multiuser document where many users can connect and read/write to the db simultaneously, and it's working perfect. Although, mostly the users will

Re: [sqlite] concurrent users?

2008-10-07 Thread Igor Tandetnik
"Shawn Anderson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've read many things, some conflicting, about concurrent users on a > Sqlite database. > The feeling I get is that Sqlite is good for a standalone desktop > database, but should not be used in a concurrent user