Why are you comparing these two? If it's just curiosity, that's fine. If you're looking for a technology solution, have you identified your requirements?
Those are valid questions.
The database is going to be used as a librarian and a recorder of transactions. To me it sounds simple enough that MySQL would do fine, but the CTO wants to be sure that we can do things like views, triggers and rollbacks.
My preference is for MySQL because I know it very well and it has always performed admirably, but if the CTO wants to be able to the fancier things, that's cool. I just wanted to hear about any differences or gotchas that I should worry about.
And if it should happen that we don't use the fancy stuff, I can always go back to MySQL -- Perl lets me do that :) quite painlessly, I understand.
but my friends call me T.
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:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||