Class:DBI or DBIx::Class?

sherab has asked for the wisdom of the Perl Monks concerning the following question:

Hi folks! I have always written SQL functions in Perl and have only now stumbled into Class::DBI. (I know, very late to the party). I like it enough to start using it more but am I correct in assuming that people pretty much have moved from Class::DBI to DBIx::Class now? I have never made use of these database helpers but I sure plan to from now on.

Comment on Class:DBI or DBIx::Class?

Replies are listed 'Best First'.
Re: Class:DBI or DBIx::Class? by Your Mother (Archbishop) on Oct 29, 2010 at 14:58 UTC
You are correct. DBIx::Class (DBIC) is a little trickier to get up to speed with but it is the way to go; features, community, ~~less~~ fewer limitations, extensions, extensibility. I was a huge Class::DBI (CDBI) fan but I haven't written any code with it in ... like three years or so now. Update: What molecules said++. Also might peek at KiokuDB. Perl is a banquet!	[reply]
Re: Class:DBI or DBIx::Class? by molecules (Monk) on Oct 29, 2010 at 16:57 UTC
You also might want to check out Rose::DB and Fey. As I understand it, Fey is for those who are comfortable with SQL, but would still like some power by abstraction. I think I'll use it next time I get to start fresh on a database project. If you want an ORM, there is also Fey::ORM Rose::DB was featured in a three part introduction by Randal Schwartz: Wrap your database rows with Rose (Oct 06) Setting up Rose::DB::Object Metadata (Nov 06) (code) Using Rose::DB::Object (Dec 06)	[reply]