DBIx::Class (DBIC) is generally preferred [citation needed] over Class::DBI (CDBI) for the last few years; speed and flexibility the main reasons.

You can search the monastery for quite a few nodes discussing these kits and several others worth considering; Perl ORM comparison (Class::DBI vs. DBIx::Class vs. Rose::DB::Object); google:site:perlmonks.org dbic cdbi.

With DBIC there is not really an impedance mismatch because it has the meta-considerations of records and record sets (Results/ResultSets in DBIC parlance) split nicely and each encapsulates the proper layers like engine and SQL generation. These things have steep learning curves but once you get the hang of them they make dealing with data and databases trivial, testable, flexible, perly, and largely self-documenting [citation needed].

In reply to Re: Why use an OO -> SQL mapper module? by Your Mother
in thread Why use an OO -> SQL mapper module? by MyMonkName

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.