Since you've already trolled the CPAN, I won't mention any of the modules there.

However, in the interest of completeness there is a module called something like DBIx::TableAdaptor::MySQL (Adapter?) written by Michael Granger at one time (not posted to the CPAN, though I think that was on his todo list) which offered a clever solution to referential integrity with MySQL.

He built table adapters for both MySQL and Oracle which supported a variety of additional features (e.g., the Oracle table adapter built relational objects based on Oracle's data dictionary - no configuration file needed).

Michael is one of the best Perl coders I've ever met, and very friendly to boot. I'd suggest dropping him a line.

I also have another unrelated suggestion: Be forceful and push your agenda if you have not already done so. Don't let someone tell you you can't install this or that module that you need for your work. The CPAN is all about not reinventing the wheel, and if someone tells you that you or the SA can't install a particular CPAN module, it's usually just to dissuade those who aren't serious about what they're doing. Convince them that you're serious and know what you're doing and that you really need the module in question.

Hope this helps :-)

In reply to Re: db schema modules, recommendations? by Starky
in thread db schema modules, recommendations? by converter

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.