The Underscore Archives

On Thu, 2008-01-10 at 14:21 +0000, Rick Edwards wrote:
> On 10/01/2008, amias <something at amias.org.uk> wrote:
> >
> > For what its worth i use Perl Catalyst with Class::DBIx which is
> > database neutral because it abstracts all the SQL and gives you yummy
> > objects to do all the queries and all the smugness you can eat.
> >
> 
> Is that similar to MicroSofts new Linq where you write generic db
> agnostic SQL which is then interpreted by the appropriate DB plug in?
> Quite like this idea of abstracting out the data access layer even
> further.

prolly , they have a habit of ripping off good ideas but missing the
best part ;)

I use Class::DBIx and SQL::Abstract which means i don't have to write
any SQL at all ( not that i can't ) , its methods and monster data
structures all the way baby.

Its a bit head scrambling at first but its a proper abstraction in that
you don't have to worry about joins and indexes , oh and it goes like
shit of a shovel and can auto update to support new foreign tables if 
the database structure implies it.

The other cool thing with this is that you can drop your entire DB
implimentation in to another app in seconds.

Toodle-pip
Amias

-- 
 Freelance programming , consultancy and hardware builds
blog.amias.org.uk * www.amias.org.uk * www.ecotalk.org.uk