laziness, impatience, and hubris | |
PerlMonks |
Re: I have a generalized "from XML to SQL" chore... best way?by trwww (Priest) |
on Mar 01, 2008 at 09:32 UTC ( [id://671353]=note: print w/replies, xml ) | Need Help?? |
Hello, Assuming that the XML file takes a "each child of the root node is a record" layout, the first thing I would do is turn each record in to a data structure. An easy way to do this while keeping efficiency in mind is with Jenda's XML::Rules (see also node #582348). Then personally I would use Data::FormValidator to validate and manipulate each record. And then probably DBI or maybe an ORM to insert the data in to the db. trwww
In Section
Seekers of Perl Wisdom
|
|