Sqlite limit

Rails
1

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

2

On Wed, Sep 30, 2009 at 10:45 PM, kashyap [email protected] 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?

Should be fine, you can find more info here:

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

Regards,
Kashyap

–
Kind Regards,
Rajinder Y.

http://devmentor.org
Do Good! ~ Share Freely

3

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,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

4

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

On Fri, Oct 2, 2009 at 12:55 AM, Rajinder Y. [email protected]
wrote:

http://devmentor.org
Do Good! ~ Share Freely

–
Regards,
Kashyap