From: Tom Allison <tallison@...>
Date: 2006-03-26T13:47:57+09:00
Subject: Re: Best Database For Ruby

Reid Thompson wrote:
> Pat Maddox wrote:
> 
>> On 3/25/06, Reid Thompson <reid.thompson@ateb.com> wrote:
>>  
>>
>>> Butternut squash wrote:
>>>    
>>>
>>>> I want to learn DB and SQL using Ruby
>>>>
>>>> Project is not too big. Probably need 30 tables
>>>>
>>>> Everyone at work tells me MySQL is the best... I used to use 
>>>> Informix a long
>>>> time ago. It doesn't look like I can get this for linux.
>>>>
>>>> thanks in advance.
>>>>
>>>>
>>>>       
>>>
>>> PostgreSQL www.postgresql.org

I think the debate between Postgres and MySQL is about as inflammatory as vi and 
emacs.  However I'm of the opinion that Postgres is ultimately a better database 
if you are going to do real database things where the data is changing 
frequently (INSERT, UPDATE, DELETE) as opposed to just reading it.

But I haven't any hard metric data to support any of this.

Unless there's something specifically ruby-esque to make the advantage clearer.

Postgres is nicely object oriented if you are into that sort of thing.