How to convert xml to sqlite

Question

Hey guys I have a xml file that has a lot of info that I would like it to be in sqlite tables.

I am wondering if there's any tool, app to transform xml to sqlite.

By the way I am on OS X and I need the info for an iPhone app, so I can also take scripts or some source code to make the trasmformation.

Best Regards. Carlos Vargas

Answer 1

Use XSLT to transform the XML into insert statements.

Answer 2

The SQLite Manager firefox plugin has an XML importer : http://code.google.com/p/sqlite-manager/

The XML import / Export is described here :

http://code.google.com/p/sqlite-manager/wiki/FAQ#XML_import_and_export