From: Raphael Bauduin <raphael.bauduin@...>
Date: 2004-04-21T00:39:11+09:00
Subject: Re: The quest for opensource database...

Ruby Tuesdays wrote:
> Perhaps you database guru able to suggest what would be a good choice for
> opensource database platform to use to develop projects.
> 
> At the moment the project is small/medium, but it will grow in size both
> data, users, and number of transactions. I'm using MySQL for right now but
> it lack of trigger, stored procedures, etc ... it sometimes slows the
> project.
> 
> Is PostgreSQL any better/worse? Or is that any other choice beside the two?
> Thanks.
> 
> 
Using postgres and satisfied (I couldn't work without triggers).
I heard that with tables with millions of entries, postgres could become rather slow.
I used postgres both with the ruby-dbi and native interfaces without problems.

I program the functions used by the triggers in plpgsql (there's a project to let you program the postgres functions in ruby, but it was unstable last time I looked at it).

Firebird (which is indeed coming from Interbase) is also a possibility, but I have no experience with it.

Raph