From: Peter Hickman <peter@...>
Date: 2003-11-20T21:34:42+09:00
Subject: Re:

Jesper Olsen wrote:
> I am currently using ruby's mysql extention.
> Recently PostgreSql has become available to me also.
> 
> PostgreSql is not part of the ruby distribution, but I notice that
> there is an extention available for it:
> 
> http://www.postgresql.jp/interfaces/ruby/reference.html
> 
> I think the Ruby API's are more or less the same?
> 
> Maybe this not strictly a ruby question, but can anyone here comment on
> how MySQL and PostgreSQL compare?
> Is PostgreSQL in any way better than MySql - ie. faster or more stable.
> 
> Cheers
> Jesper
> 
> 
> --
> http://JesperOlsen.Net
> 
> 

PostgreSQL has stored procedures and MySQL doesn't (although a new derived 
version of MySQL does - recently announced, I know nothing about it).

I think PostgreSQL also has constraints and triggers that MySQL doesn't / 
might not have.

We use PostgreSQL but for your needs (whatever they are) MySQL could be perfect.

Haven't used MySQL in a few years but I liked it when I used it.