I just have to ask why you are using MySQL if you want rollbacks, transactions, etc.

MySQL is built for speed at the cost of features. I imagine someday they'll fit in these features if they can figure out a way to do it which won't interfer with their primary goal. MySQL is good if you want a fast database and don't care about things like transactions. That's not what I'd opt for with an e-commerce site (although I would use it for something like a discussion site). Given the fact that you're talking about transactions makes me think that it's not the best choice for your project.

I would therefore suggest using Oracle, so that your boss has to pay and pay and pay like he deserves.

You might also want to take a look at PostgreSQL. It's open-source and supports transactions. Version 7.0 was just released about a week ago. That way you'd have all the features and the only code he'd own would be whatever you wrote to interface with the database, which he wouldn't be able to sell.

There was recently a discussion about MySQL, Postgres and ACID which you might find of interest, as you are bringing up some of the same issues.

In reply to RE: Perl Werk Question. Please Help. Part 0. (kudra: why use MySQL for transactions?) by kudra
in thread Perl Werk Question. Please Help. Part 0. by PipTigger

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.