[sf-perl] Going from XML to SQL

Joseph Brenner doom at kzsu.stanford.edu
Wed Mar 23 19:26:22 PST 2005

Before the last meeting, Rich Morin and Josh Berkus were talking
about the issues involved with translating data structures
between XML to SQL. I just came across something on CPAN that
looks relevent, DBIx::DBStag::Cookbook:


    This will give an outline of how to build a normalised
    relational database from XML source data, set up SQL
    templates, issue relational queries that return hierarchical
    results (as XML or as perl objects), and autogenerate a web
    query front end for this data.

    Why would you want to do this? Well, it gives you the full
    power of the relational model and SQL, combined with the
    convenience of representations which allow for the nesting of
    data entities (SQL query results are typically flat relations
    which are inconvenient for complex hierarchical data).

The "Stag" concept is funny... a generalization of XML and sexps:



   This perl module is for querying and manipulating complex data
   as recursively nested tag/value pairs (Structured tags or
   Simple Tree aggreggates). Procedural and object-oriented modes
   are supported. Tags can be accessed by autogenerated accessor

   XML is a hierarchical data format, so this module can be used
   as an XML parser/writer. Other hierarchical formats are
   supported, including lisp S-Expressions (i.e. SXML) and

More information about the SanFrancisco-pm mailing list