From: Pistos Christou <jesusrubsyou.5.pistos@...>
Date: 2006-03-28T01:42:09+09:00
Subject: Re: Best Database For Ruby

Tom Allison wrote:
> Postgres is nicely object oriented if you are into that sort of thing.

Now, I don't want to veer way off topic for either this thread or this 
list, but I was wondering what brings you to say that?  I've never 
thought of any particular DB being more or less OO.

Recently, I investigated Postgres' table inheritance feature, but found 
it to be lacking in robustness.  Constraints are not carried over to 
child tables, and even if you redeclare them in child table definitions, 
UNIQUE constraints are not enforced across the rows of both tables 
(i.e., you can have a row with table1.id = 1 and a row with table2.id = 
1).

To me, this makes it (inheritance, not Postgres as a whole) seem okay 
for toy applications, but not for anything serious.

(For the record, I prefer Postgres, but only because at the time I made 
my choice, MySQL was lacking in "serious" DB features.)

/me leaves it at that, not wanting to argue PG vs. MySQL

-- 
Posted via http://www.ruby-forum.com/.