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
精彩评论