The following modules will generally help you
interact with your database table rows as Perl
objects. Some will help you construct SQL, so
that you may get away with no-SQL most of the time,
including some basic joins. The SQL that they
generate will use basic security best practices
and save you headaches. Some will help with
paging the result sets. Jifty aims to go
further and implement half your application for
you. The order, from top to bottom, seems to be
the general order of preference of wiser monks
these days. I only have significant experience
with
Class::DBI::Sweet, which does all
I need, though sometimes you have to bend backwards.
Its performance also leaves something to be desired,
especially compared to the first two, according to
some benchmarks. In my next project, I would
probably start with one of the top three.
Cheers.