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
On Wed, Sep 30, 2009 at 10:45 PM, kashyap <ckkashyap-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 Yadav http://devmentor.org Do Good! ~ Share Freely
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, > KashyapBest, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/.
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 Yadav <devguy.ca-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > On Wed, Sep 30, 2009 at 10:45 PM, kashyap <ckkashyap-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 Yadav > > http://devmentor.org > Do Good! ~ Share Freely > > > >-- Regards, Kashyap