Many SQL engines (and perl modules) are more than happy to export the tables to XML. Why? Because you can then move them somewhere else (on a disk, perhaps) to another machine, where it may be accepted happily by another dbengine (not necessarily even an SQL or the same dbengine) and still retain full use of the data (with some minor tweaking). But if, you're not doing anything like this than using XML for anything db-related is superfluous. In general speed(dbegine)>speed(DB_File)>speed(XML file) since XML is a plain text format. It will be easier and faster to extract than interpreting an XML file. But XML has other uses....but since you don't ask....

I'll answer anyway. XML was once considered a replacement for HTML- but that didn't pan out. XML makes a great human-readable config file format as well as a nice cross-platform format in general, which makes it useful in many situations...

AgentM Systems nor Nasca Enterprises nor Bone::Easy nor Macperl is responsible for the comments made by AgentM. Remember, you can build any logical system with NOR.

In reply to Re: Perl/XML/MySQL by AgentM
in thread Perl/XML/MySQL by rbottoms

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.