Re: Reusing SQL data-related logic, replacing weird modules and improving Class::DBI or adding to it

[prev] [thread] [next] [Date index for 2005/07/02]

On Sat, Jul 02, 2005 at 04:36:57AM -0400, Sebastian wrote:
> I think that mixing CDBI and something like the solution given at
> http://groups-beta.google.com/group/comp.lang.perl.modules/browse_thread/thread/266e35238f3d5df6
> could lead to some really cool things. Please have a look there and at
> the links provided in the post and provide some feedback!

Class::DBI already provides quite a few ways to set up your SQL as class
data, and to vary it depending on needs, whether through the simple
sprintf style substitutions, or through more complex transform_sql()
transformations.

What the links you've posted appear to be doing is falling back into the
trap of trying to replace SQL with Perl - something I've always said
that I don't want Class::DBI to do.

Class::DBI is for people who like SQL and think in SQL - it's not an
attempt to shield people from it. It provides a variety of tools to allow
people to abstract their SQL and remove the drudgery of repeatedly doing
similar queries. But it certainly does not attempt to remove the need for
writing SQL, not think that removing it is even a valid or sensible goal.

Tony