|P is for Practical|
I have a generalized "from XML to SQL" chore... best way?by sundialsvc4 (Monsignor)
|on Feb 28, 2008 at 18:46 UTC||Need Help??|
sundialsvc4 has asked for the
wisdom of the Perl Monks concerning the following question:
I've got several occurrences of a very general requirement: “Here is a periodic data-feed consisting of a well-formed XML document and corresponding DTD definition, and what we need to do with that information is to update an SQL database. ” We're going to have lots and lots of instances of this very same requirement, some with large files some with small, which differ only in the particulars.
As I see it, the general requirements are (and I know them to be quite commonplace...):
Now I know that CPAN has a plethora of high-level tools such as XML::Twig but I fully expect that there are higher-level tools even than this. And so I, brashly exhibiting the Core Value of “Laziness,” :-) wish to find it, not write it Yet Again.
Hence my humble supplication to the Monks. Prithee, where the magic-bullet that I have not stumbled-upon yet?
To clarify... Yes, of course, I've done a CPAN search for “XML SQL” and I see many modules here. What would really help me most is your actual hands-on experiences, your been-there done-that. If I can go as straight-a-way as possible to the best overall solution for my chore, in one swell foop, I Will Be A Very Happy Boy.