External databases are great things, but they are not a panacea. It is nice, at university, to think of a database as that separate black box that data goes into and out of and is all nicely managed for you.

Having seen databases used in different companies (such as Sybase, Oracle, PostgreSQL, MySQL, and Informix) and used a few, although being no DBA myself, I've come to realise that each DB behaves in different ways and every single one needs a lot of hand holding.

It pays to keep a close eye on a new system. The problem is that your use of a database can be just as much of a problem as the application you just wrote and (rightly so) assume to be the most likely source of the fault compared to this off-the-shelf application that's a mature product.

I liked your post, have upvoted it, as I think it's a great learning experience any time you realise a fault is somewhere you didn't think before. Well done!

In reply to Re: Make sure you're solving the right problem by monarch
in thread Make sure you're solving the right problem by talexb

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.