[Dbix-class] review of various RDBMS ?

[Joel Bernstein]

On Mon, Jul 16, 2007 at 12:23:46PM +0200, Marc Espie wrote:
> I was wondering if some people have played with various RDBMs, and what
> they think of them.

I think you mean ORMs (object-relational mapper e.g DBIC, CDBI, RDBO,
Tangram, Hibernate etc) not RDBMS (relational database management 
system e.g. Oracle, DB2, Sybase, Postgres, MySQL, MSSQL) don't you?

> Initially, not knowing very much, I came to DBIx::Class. I still follow
> the list and look at it, but I am currently exploring Rose::DB::Object.
<snip list of pros and cons>

> As far as I'm concerned, not finding full support in DBIx::Class wrt
> many-to-many was the point that made me look elsewhere... and merlyn's
> columns decided me to have a look at Rose::DB::Object.

In some ways you're comparing apples with Wednesday. What do you mean by
'full support'? DBIC has /some/ many-to-many relationship support - see
DBIx::Class::Relationship - has_many(), belongs_to(), many_to_many().
If you can express a query you'd perform in SQL, you can use DBIC's
SQL::Abstract support to perform a join that isn't directly supported by
the higher level API.

/joel