Rails - Feb 2005 - New rails user database question

I''m currently using Perl, Class::DBI, Template Toolkit on top of Mysql
and I''m about to try my hand at a first Rails app.  The power of Rails
and Ruby has me very intrigued...  The O-R mapping in Class::DBI seems
to be covered by AR, so I''m hoping it is a workable proposition.

I plan to build a simple test case to get up to speed before
converting a large production system.

Since I''m planning such a major switch, I''m reconsidering
database
choices too.  I think I want to switch to either Mysql Innodb or
Postgres to pick up referential integrity.

I know this is a hard question -- but can anyone make any
recommendations as to which is a better choice for a Rails app?  My
application is pretty-low volume (a few transactions per second), so
while performance is always important, I would gladly give up some
speed for more robustness.

I have no real experience with Postgres, but I am leaning towards it
because it seems more robust (of course I''m coming from Mysql myisam,
I know InnoDB would be a step up).  How well is postgres supported for
Rails app?  Does it lack any functionality of the Mysql adaptor?

Thanks,
--Mike

Mike Carlton wrote:
> I have no real experience with Postgres, but I am leaning towards it
> because it seems more robust (of course I''m coming from Mysql
myisam,
> I know InnoDB would be a step up).  How well is postgres supported for
> Rails app?  Does it lack any functionality of the Mysql adaptor?
MySQL InnoDB and PostgreSQL are on nearly equal footing.  I''d stick
with
MySQL since you''re familiar with it.  PostgreSQL is pretty cool,
though,
if you want some disruptive change for its own sake.

jeremy