[Catalyst] Alternatives to DBIx?

John Karr brainbuz at brainbuz.org
Sat Apr 17 23:04:58 GMT 2010

I think there's a very important difference of approach, much as Template Tool Kit and Template Declare, radically different approaches, that are both far superior to the classic CGI Module. 

Working in raw DBI is the opposite of the DRY principle which underlies having a framework in the first place, so I am seeking an alternative. Just as Catalyst uses MVC, DBIx chooses ORM, but that paradigm is not the only way to be effective PERL<==>SQL glue. From the Manpage Fey::SQL looks like what I want: neatly wrapped and sweetened SQL, without the repetition and overhead inherent in working from DBI. I'm going to spend some time working with it and also with SQL::DB, when I have a more educated opinion I will share it. Both Fey and SQLDB are a nativist approach to SQL (much like TT is to html), and I would argue that in keeping the PERL paradigm of many ways to accomplish a task, the choice between a SQL-native DBI wrapper and an ORM wrapper should be up to the individual, the issue seems to be finding a worthy SQL-native wrapper.

In my own analysis the Time and Effort to learn DBIx is greater than the Time wasted writing repetitious DBI code, the time I've already invested on DBIx has shown that there is a better way than DBI, but for me it isn't DBIx.

-----Original Message-----
From: Octavian Rasnita [mailto:orasnita at gmail.com] 
Sent: Saturday, April 17, 2010 3:58 PM
To: The elegant MVC web framework
Subject: Re: [Catalyst] Alternatives to DBIx?

From: "Kiffin Gish" <kiffin.gish at planet.nl>
> I'd say that rather than spending time studying SQL::DB, which I found
> complicated and hard to tackle, you might as well invest the same time
> and energy anyway in figuring out DBIx::Class.

BTW, is there a comparison among the ORMs in Perl somewhere?
It would be interesting and definitely helpful for the ORM newbies.


List: Catalyst at lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/

More information about the Catalyst mailing list