[Dbix-class] DBIx::Class or Rose::DB::Object or other???

[Kurt Hansen]

Hello,

Last summer, I started developing new applications using Class::DBI 
rather than my own home grown DBI modules.

A few weeks ago, I saw a reference on the mod_perl list to the benchmark 
page:
http://rose.sourceforge.net/wiki/index.php/RDBO/Benchmark

Rather than sticking with Class::DBI, I am looking to switch to 
Rose::DB::Object or DBIx::Class or (maybe there is some other out 
there??). I'm trying to understand what the differences are and which 
are relevant for my environment. So far, this is what I've picked up 
(yes a bit slim):

1. RDBO is faster.
2. DBIC has a Class::DBI compatibility layer that will make the 
transition from CDBI easier

Any other key things I should note? Also, will the speed advantage of 
RDBO be maintained, or are both such young modules that it's hard to say 
where the speed advantage will end up?

I develop using HTML::Mason in a mod_perl environment. My db management 
system is MySQL, and the databases being developed are normalized with 
multiple foreign keys.

I figure that if I had asked this question a year ago on the CDBI list, 
I probably would be ahead of the game now with either RDBO or DBIC. ;-)

I'll do my best to summarize the responses and put them on both lists 
for future reference; I'm sure it is a question others have.

Thanks for your attention.

Take care,

Kurt Hansen
khansen at charityweb.net