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