I read the article as well, but while I found the artcile itself to be good, I disagree with the DBIx concept. Writting DBI without SQL has to be the same feel as driving a Porsche with auto-transmission. I like SQL and enjoy having absolute control over every little detail, but then again, that's my bad. :)

It seems to be that DBIx is (yet another) layer between the application and the database. The concept seems to interesting at first, but once you stop and think of it, whats the point really? Getting you to do you're work faster? More portability? Those can be acheived by knowing your tools better and finding a least common denominator.

That's what I do with SQL (and HTML). I have the exact oposite setup that you do. I'm writing SQL for MySQL and porting it to Oracle later on. Finding the least commong denominator between the both isn't that hard. I just run a Find/Replace on varchar, enum, int, and fields of the sort and then go through manually and find whatever needs special attention. I find that to be more practical, safer, and it usually on takes an extra 15 minutes per database.

Just my usual R$0.02...

#!/home/bbq/bin/perl
# Trust no1!

In reply to RE: RE: DBIx::Recordset article (please review) by BBQ
in thread DBIx::Recordset article (please review) by princepawn

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.