# OT : SQLite or another database engine with a small application?

**URL:** <https://www.ruby-forum.com/t/ot-sqlite-or-another-database-engine-with-a-small-application/165833>\
**Category:** Rails\
**Created:** [April 17, 2009, 11:45pm UTC](https://www.ruby-forum.com/t/ot-sqlite-or-another-database-engine-with-a-small-application/165833 "2009-04-17T23:45:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cesarstafe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/779978/32.png) [@cesarstafe](https://www.ruby-forum.com/u/cesarstafe)\
**Post date:** [April 17, 2009, 11:45pm UTC](https://www.ruby-forum.com/t/ot-sqlite-or-another-database-engine-with-a-small-application/165833/1 "2009-04-17T23:45:50Z")

</div>

People,  
I have been thinking at this for long time and I do not know  
if SQLite is sufficient for my application.  
I developed an inventory system in Rails -v 2.2.2 and I do  
not know if SQLite is the best choice or if is neccesary have a bigger  
database engine than SQLite…  
This site will not has thousand and thousand records or  
visits each day so I think with SQLite could be suficient. So, can  
anybody tell me what think about this?

```
     Thanks in advance

             Cesar

```

* * *

[http://www.sindominio.net/ayuda/preguntas-inteligentes.html](http://www.sindominio.net/ayuda/preguntas-inteligentes.html)  
[http://cronopios.net/Traducciones/trolls.es.html](http://cronopios.net/Traducciones/trolls.es.html)  
Gnu/Linux count user #416024

Pagina personal : [http://www.cesardiaz.com.ar](http://www.cesardiaz.com.ar)  
Mi blog : [http://cesarediaz.blogspot.com](http://cesarediaz.blogspot.com)  
Twitter : [http://twitter.com/cesarstafe](http://twitter.com/cesarstafe)  
Skype: cesarstafe

---

<div class="post-metadata">

**Author:** ![cesarstafe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/779978/32.png) [@cesarstafe](https://www.ruby-forum.com/u/cesarstafe)\
**Post date:** [April 18, 2009, 1:40am UTC](https://www.ruby-forum.com/t/ot-sqlite-or-another-database-engine-with-a-small-application/165833/2 "2009-04-18T01:40:02Z")

</div>

On Fri, Apr 17, 2009 at 10:44 PM, César [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 

Hi Cesar,

This topic has been discussed before, but my suggestion is to go with  
MySQL. Use SQLite only for development.

Fidel.

---

<div class="post-metadata">

**Author:** ![cesarstafe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/779978/32.png) [@cesarstafe](https://www.ruby-forum.com/u/cesarstafe)\
**Post date:** [April 18, 2009, 3:01pm UTC](https://www.ruby-forum.com/t/ot-sqlite-or-another-database-engine-with-a-small-application/165833/3 "2009-04-18T15:01:27Z")

</div>

Many thanks Fidel. My apologizes to the list for re discuss something.

Well, in my opinion if I have to select another database engine I will  
work with Postgres because I see this engine more powerful, more solid  
than MySql. It is just my opinion, MySql is good but I prefer  
Postgres.

Cesar

* * *

[http://www.sindominio.net/ayuda/preguntas-inteligentes.html](http://www.sindominio.net/ayuda/preguntas-inteligentes.html)  
[http://cronopios.net/Traducciones/trolls.es.html](http://cronopios.net/Traducciones/trolls.es.html)  
Gnu/Linux count user #416024

Personal page : [http://www.cesardiaz.com.ar](http://www.cesardiaz.com.ar)  
My blog : [http://cesarediaz.blogspot.com](http://cesarediaz.blogspot.com)  
My repository: [cesarediaz (Cesar Diaz) · GitHub](http://github.com/cesarediaz/)  
Twitter : [http://twitter.com/cesarstafe](http://twitter.com/cesarstafe)  
Skype: cesarstafe

---

<div class="post-metadata">

**Author:** ![cesarstafe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/779978/32.png) [@cesarstafe](https://www.ruby-forum.com/u/cesarstafe)\
**Post date:** [April 20, 2009, 11:01am UTC](https://www.ruby-forum.com/t/ot-sqlite-or-another-database-engine-with-a-small-application/165833/4 "2009-04-20T11:01:58Z")

</div>

On Sat, Apr 18, 2009 at 2:00 PM, César [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Many thanks Fidel. My apologizes to the list for re discuss something.
> 
> Well, in my opinion if I have to select another database engine I will  
> work with Postgres because I see this engine more powerful, more solid  
> than MySql. It is just my opinion, MySql is good but I prefer  
> Postgres.

Certainly!

I only suggested MySQL because of the requirements you specified.

Fidel.