# Sqlite limit

**URL:** <https://www.ruby-forum.com/t/sqlite-limit/176477>\
**Category:** Rails\
**Created:** [October 1, 2009, 4:46am UTC](https://www.ruby-forum.com/t/sqlite-limit/176477 "2009-10-01T04:46:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kashyap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/bbe5ce/32.png) [@kashyap](https://www.ruby-forum.com/u/kashyap)\
**Post date:** [October 1, 2009, 4:46am UTC](https://www.ruby-forum.com/t/sqlite-limit/176477/1 "2009-10-01T04:46:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![kashyap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/bbe5ce/32.png) [@kashyap](https://www.ruby-forum.com/u/kashyap)\
**Post date:** [October 1, 2009, 9:26pm UTC](https://www.ruby-forum.com/t/sqlite-limit/176477/2 "2009-10-01T21:26:49Z")

</div>

On Wed, Sep 30, 2009 at 10:45 PM, kashyap [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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/docs.html)  
[http://sqlite.org/lockingv3.html](http://sqlite.org/lockingv3.html)

> Regards,  
> Kashyap

–  
Kind Regards,  
Rajinder Y.

[http://devmentor.org](http://devmentor.org)  
Do Good! ~ Share Freely

---

<div class="post-metadata">

**Author:** ![kashyap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/bbe5ce/32.png) [@kashyap](https://www.ruby-forum.com/u/kashyap)\
**Post date:** [October 1, 2009, 9:40pm UTC](https://www.ruby-forum.com/t/sqlite-limit/176477/3 "2009-10-01T21:40:57Z")

</div>

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](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![kashyap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/bbe5ce/32.png) [@kashyap](https://www.ruby-forum.com/u/kashyap)\
**Post date:** [October 2, 2009, 7:13am UTC](https://www.ruby-forum.com/t/sqlite-limit/176477/4 "2009-10-02T07:13:23Z")

</div>

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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> [http://devmentor.org](http://devmentor.org)  
> Do Good! ~ Share Freely
> 
> >

–  
Regards,  
Kashyap