What database do you use most often? Is it because you want to or some other reason? Is there a particular reason it stands out for you if it's because you want to?

I think most of use the database that our employer already has in place, and few have the luxury of "choosing" one. (Of course, you can choose where to work based in part on what database they have). I tend to "choose" mySQL for my personal needs because of it's price, but would probably use Oracle if money was not an issue.

To answer the main question, I currently use Oracle and Sybase mostly, and greatly prefer Oracle for the most part. I disagree with one of the statements above however - I vastly prefer case-insensitive databases, particularly ones that I have not designed, because it's real easy to make a typo when saying something like: 

select Foo_Bar from ReceivableTransaction_Logs_Nightly

[download]

(No, I wouldn't have come up with such horrendous naming conventions, but it's not often you work in a legacy-free workplace :)

Besides, SQL isn't case sensitive, so why not make the database objects the same way. :)

In reply to Re: What databases are monks using? by turnstep
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.