[Dbix-class] review of various RDBMS ?
joel at fysh.org
Mon Jul 16 11:59:22 GMT 2007
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.
More information about the Dbix-class