# Which database to use?

**URL:** <https://www.ruby-forum.com/t/which-database-to-use/59520>\
**Category:** Rails\
**Created:** [May 3, 2006, 7:43pm UTC](https://www.ruby-forum.com/t/which-database-to-use/59520 "2006-05-03T19:43:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jon-d](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/ecccb3/32.png) [@jon-d](https://www.ruby-forum.com/u/jon-d)\
**Post date:** [May 3, 2006, 7:43pm UTC](https://www.ruby-forum.com/t/which-database-to-use/59520/1 "2006-05-03T19:43:34Z")

</div>

Hello all,

i’ve been coding rails now for a few months and seem to always run into  
problems with the database i’m using. i’m using mysql 5.0 with the query  
browser, alsom i’m on an iMac intel. so what is the best setup? any  
ideas would be greatly apprectiated.

---

<div class="post-metadata">

**Author:** ![jon-d](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/ecccb3/32.png) [@jon-d](https://www.ruby-forum.com/u/jon-d)\
**Post date:** [May 3, 2006, 8:09pm UTC](https://www.ruby-forum.com/t/which-database-to-use/59520/2 "2006-05-03T20:09:55Z")

</div>

Jon Mr wrote:

> Hello all,
> 
> i’ve been coding rails now for a few months and seem to always run into  
> problems with the database i’m using. i’m using mysql 5.0 with the query  
> browser, alsom i’m on an iMac intel. so what is the best setup? any  
> ideas would be greatly apprectiated.  
> What sort of problems are you having?

There isn’t really a ‘best setup’, per se, but a lot of people seem to  
prefer PostgreSQL for one reason or another. Personally, I tend to use  
SQLite in development, but I don’t know how well that flies on an intel  
mac.

---

<div class="post-metadata">

**Author:** ![jon-d](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/ecccb3/32.png) [@jon-d](https://www.ruby-forum.com/u/jon-d)\
**Post date:** [May 3, 2006, 8:31pm UTC](https://www.ruby-forum.com/t/which-database-to-use/59520/3 "2006-05-03T20:31:13Z")

</div>

On 5/3/06, Jon Mr [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> i’ve been coding rails now for a few months and seem to always run into  
> problems with the database i’m using. i’m using mysql 5.0 with the query  
> browser, alsom i’m on an iMac intel. so what is the best setup? any  
> ideas would be greatly apprectiated.

You’ll get more meaningful answers if you can define “always run into  
problems” more exactly.

– James

---

<div class="post-metadata">

**Author:** ![jon-d](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/ecccb3/32.png) [@jon-d](https://www.ruby-forum.com/u/jon-d)\
**Post date:** [May 3, 2006, 8:40pm UTC](https://www.ruby-forum.com/t/which-database-to-use/59520/4 "2006-05-03T20:40:29Z")

</div>

On Wed, May 03, 2006 at 07:43:34PM +0200, Jon Mr wrote:  
} i’ve been coding rails now for a few months and seem to always run  
into  
} problems with the database i’m using. i’m using mysql 5.0 with the  
query  
} browser, alsom i’m on an iMac intel. so what is the best setup? any  
} ideas would be greatly apprectiated.

I generally recommend PostgreSQL for anything short of commercial  
deployment. It can also be appropriate for commercial deployment, mind  
you,  
but there are commercial databases worth considering for that.

–Greg