oblate kramrdc has asked for the wisdom of the Perl Monks concerning the following question:

Hi fellow monks!

I have a website that contains xml data and I want to extract those xml data and store it into a SQL database.

Is there a way to do this?

Any help would be greatly appreciated!

Thanks!

Replies are listed 'Best First'.
Re: extract data from website to sql
by jZed (Prior) on Feb 21, 2007 at 06:52 UTC
    The DBD::AnyData module can work with local or remote files (it uses LWP under the hood) and can work with XML files that have a structure similar to a database table (it uses XML::Twig under the hood). You can use AnyData to convert the remote file to a local CSV file and then import that into a database or else use AnyData with another DBI driver to insert the data directly from the remote file into PostgreSQL or MySQL or whatever without any intermediate file saving.
[reply]
Re: extract data from website to sql
by ikegami (Patriarch) on Feb 21, 2007 at 06:30 UTC
[reply]

Back to Seekers of Perl Wisdom