sqlite limit

Hi All,
I am working on a POC that I'd like to show a group of 10 to 15 folks.
I was wondering if sqlite would do for db with about 20 people hitting
on the application. Does sqlite locking the entire db while writing
manifest itself in such scenario?
Regards,
Kashyap

Hi All,
I am working on a POC that I'd like to show a group of 10 to 15 folks.
I was wondering if sqlite would do for db with about 20 people hitting
on the application. Does sqlite locking the entire db while writing
manifest itself in such scenario?

Should be fine, you can find more info here:

http://sqlite.org/docs.html
http://sqlite.org/lockingv3.html

kashyap wrote:

Hi All,
I am working on a POC that I'd like to show a group of 10 to 15 folks.
I was wondering if sqlite would do for db with about 20 people hitting
on the application. Does sqlite locking the entire db while writing
manifest itself in such scenario?

From what I understand, this is not a great idea. Use a real multiuser
database such as PostgreSQL.

Regards,
Kashyap

Best,

Thanks Rajinder/Marnen,

From the sqlite doc it looks like I can go ahead with it ... ofcourse,
for the real stuff, I'd go with PostgreSQL

Regards,
Kashyap