Hard to say. It very much depends on your goals. If you write an application that you want to sell, or have used, by as many people as possible, and your main use of the database is to store a bit of data, it makes sense to go for database independance. OTOH, if you are writing a specific application to be run by your company, and your company only, and your company has been using Oracle for hundreds of applications for the past 20 years, it's not very likely there will be a need to run your application on DB2 anytime soon.

It's similar to the question how portable Perl applications should be. It always involves trade-offs. If it's more portable, it can be deployed on more platforms. But it might mean the code is more complex, or less efficient. How much more efficient will depend on your data, and how you have of it. If being more portable means your queries that twice as much (because you can't use a cool database dependent feature), it matters if it means that the queries now takes 0.2 instead of 0.1 seconds, or 10 minutes instead of 5.

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