I've used Sybase, MSSQL, MySQL, Postgres, and seemingly every .{1,2}?DBM in the fricking universe. Sybase has never failed me, tho I often failed it. MySQL is great till you advance past its abilities and for some projects it is indispensible. Prosgres is fast, free and has a bit more meat on the bone than MySQL. MSSQL I rate up there excepting only the first two letters. =) Just make sure you go though the options and turn off the MS weirdness modes.

I also tend to do things in Perl that I should do in SQL. It pays off when you may switch DBs but it kills you when you start to spread out and have to keep copying rules and tests about. Put the rules in Modules and you wind up adding a million methods to the Module or turning it into a spaghetti-calling nightmare with all the logic hid from you.

I suggest if it is time to fix your habits that you move the data correctness rules to the DB first. Don't get fancy, just setup case controls and ranges and such. Ease up on contorted tainting and start testing your inserts for failure. I was really pleased with myself for ust going that far =)

--
$you = new YOU;
honk() if $you->love(perl)

In reply to Re: What databases are monks using? by extremely
in thread What databases are monks using? by jptxs

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.