From: Erwin Moller <since_humans_read_this_I_am_spammed_too_much@...>
Date: 2004-04-21T17:49:12+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.

Postgresql is VERY robust and VERY rich with features.
You'll love it. I know I do. :-)

Triggers are implemented. As are serial (autonumber), PK, FK, and all other 
types of constraints you can conjure up.

A very strong language for scripting stored procedures is implemented too. 
(named: plpgsql)

exporting, backing up, everything is there.

Redhat even developed a very nice GUI for Postgresql 7.3, which they call 
RHDB (RedHatDataBase) which is actually Postgresql 7.3 (i didn't find any 
differences)
It is called Database Administrator for Postgres Redhat edition3.

I am still running their alpha, but it works like a charm, so why update?

I hope I sound enthousiastic enough, because I really like postgresql. :-)

Regards,
Erwin Moller