On one hand there are all kinds of project in Perl such as Class::DBI that help you avoid writing any SQL and try to help you eliminate any database specific issues. That it, I get database independence but I pay by performance.

On the other hand I could write SQL queries and stored procedures that would make my whole application much more efficient but will tide me to one specific database.

It seems that the Perl people (and probably this is true for other programming languages too) will try to hide any SQL and make sure you are database independent. At the same time the database people will try to make sure that you are actually writing most of the business logic within their framework using their stored procedures etc.

I have been using CDBI a lot in my recent projects and works but I think I am missing some great opportunities that I don't dive deep in the capabilities of one of the databases.

How much do you use database specific features in your applications ?

In reply to Should it be database independent? by szabgab

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.