There's no one answer here, except perhaps for "it depends". Use whatever tool is best suited to getting the job done that you need to do while simultaneously trying to be sufficiently forward looking that you do not paint yourself into a corner. Sounds easy, doesn't it?

For most small projects, you probably don't need the high octane solution of hand crafted SQL. As such, pick a good framework and exploit it's abstractions to your advantage. If your requirements start bumping up against the limitations of its feature set, then try looking for another framework that provides the features you need, or perhaps consider contributing to that framework by augmenting its feature set. Of course, the latter might not be an option, as one of the features of a framework may be that it is compact. Simplicity itself can be a feature, and adding too much to a framework can be just as harmful as leaving certain things out.

Of course, even if you decide to implement a roll-your-own solution, you'll probably end up creating a framework of sorts for yourself. You'll see all sorts commonality between various tasks and want to create an abstraction. Beware feature creep.


In reply to Re: Should it be database independent? by skyknight
in thread 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.