Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: XML to SQL - the easy way?

by happy.barney (Friar)
on Jun 09, 2011 at 08:35 UTC ( [id://908865]=note: print w/replies, xml ) Need Help??


in reply to XML to SQL - the easy way?

It depends on XML structure and required behaviour, but proper tool to transform XML to anything is XSLT.

Replies are listed 'Best First'.
Re^2: XML to SQL - the easy way?
by Jenda (Abbot) on Jun 10, 2011 at 09:20 UTC

    Yeah, proper tool. XML in XML that XML XML xml to xml in XML and xmls xml xml. Now how do you propose to use XSLT in this case? Write a complicated and fragile template that transforms the XML file into a bunch of INSERT statements (most likely failing to decode and escape the values properly) that you then force the database to parse and execute? Sounds very xmlish to me. XSLT also known as "I was lazy to design a sensible syntax and write a parser so let's force the developers to give us the syntax tree serialized in a format we already have a parser for" is seldom the right tool, but in this case it's simply ... not a good option.

    Jenda
    Enoch was right!
    Enjoy the last years of Rome.

Re^2: XML to SQL - the easy way?
by DrHyde (Prior) on Jun 10, 2011 at 10:12 UTC
    Ahhh, XSLT. The only language with more brackets than LISP.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://908865]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2025-07-18 04:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.