How to convert xml to sqlite?

I have an xml file that has a lot of info that I would like it to be in sql开发者_如何转开发ite 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.

---

Use XSLT to transform the XML into insert statements.

---

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