The only thing that bothers me about DBIx::Class is, the last time I used it, when the operations you needed surpassed a certain level of complexity, you ended up still passing in SQL syntax in scalar references at certain points, for example when I wanted to select for a column which was within a particular range of values (dates). If you get to that point, you're losing out on the benefit of the abstraction because now you have to have familiarity with the plain SQL as well as the DBIx::Class abstraction. However, I don't know that my experience was typical, or even if I was doing things the right way. YMMV.

In reply to Re: Switch from DBI to DBIx::Class: thoughts? by bellaire
in thread Switch from DBI to DBIx::Class: thoughts? by frew

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.