From: Dave Howell <groups@...>
Date: 2006-03-28T11:34:01+09:00
Subject: Re: Best Database For Ruby


On Mar 25, 2006, at 14:48, 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.

Well, apparently you can, according to somebody else's post. However, 
if that still doesn't appear to be a good choice, I'd also have to 
recommend PostgreSQL over MySQL. I learned SQL on Microsoft SQLServer 
6.5, and PostgreSQL generally acted a lot more like what I was 
expecting than MySQL could. MySQL has grown a lot since I checked them 
both out, but so has Postgres, and I still find Postgres's behavior to 
be closer to what I've come to expect out of a "real" SQL relational 
database. It's more paranoid about data integrity, for one thing, and 
is willing to let me enforce very strict measures indeed.

The biggest nuisance is that outer joins use a very different syntax 
than what I'm used to. {shrug}