Just another Perl shrine | |
PerlMonks |
I have a generalized "from XML to SQL" chore... best way?by sundialsvc4 (Abbot) |
on Feb 28, 2008 at 18:46 UTC ( [id://670977]=perlquestion: print w/replies, xml ) | 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. Thanks!
Back to
Seekers of Perl Wisdom
|
|