XML in SQLite?

[Pat Dooley]

Has anyone explored the idea of storing xml in SQLite? The idea I had involved a database with all the tables and fields the app needs, but also including a linked table with a column containing xml. This column would allow the user to store whatever extra information they wanted to store on a per record basis.

Jose's xmllite interface would seem to provide the functionality needed, but lot's of questions remain. But even with that, I would have quite a learning curve.

Is it even an idea worth considering? How to display the data? Treeview perhaps? Could specific elements (or is it nodes) be searched? I can imagine that something like the structure of a ini file might serve the same purpose.

It seems interesting, but maybe that's all it is. Just interesting.