[sf-perl] Some well-formed XML?

David Fetter david at fetter.org
Tue Sep 20 10:42:34 PDT 2005


On Tue, Sep 20, 2005 at 10:35:07AM -0700, Rich Morin wrote:
> There are several ways to describe XML documents, including schemas,
> DTDs, Relax NG, etc.  Unfortunately (AFAIK), none of these get past
> the "syntax" layer, to any degree.  For example, if I have an XML
> document that is going to be used to load an RDBMS, how would I say
> which lists go into which tables, which "columns" are keys, etc?

You can get a pretty good start with pgxml. :)

http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/

Although it's not obvious to me how you'd automatically turn a tree
into a database schema, you do have options for manipulating whole XML
documents or sets of same.

Cheers,
D
-- 
David Fetter david at fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!


More information about the SanFrancisco-pm mailing list