I touched on a similar topic in my blog: http://www.nedbatchelder.com/blog/200411.html#e20041117T084310
The comments there got distracted onto the question of how to use XML data in a relational database, and pointed off to http://www.sqlxml.org/ and http://www.sqlx.org/ There was a suggestion to use XMLSpy, as it will connect to a database and generate XML Schema for your tables. I haven't tried it though. For my purposes, I ended up using a simple ad-hoc XML file. --Ned. -----Original Message----- From: Keith Herold [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 3:25 PM To: sqlite-users@sqlite.org Subject: [sqlite] Good db XML datastructure? Hi all; I have been trying to find a good XML schema for describing databases, so that I can, among other things, produce documentation for my database format. Is there a good (free) one already out there, that is genarally accepted/used? I'm not looking to export data, just the description of the database (i.e., schema, comments, etc.) -- Keith ****************************************************** - Ever notice how 'big' isn't, compared to 'small'? - Sounds like a Wookie; acts like mad cow. - I'm not a professional; I just get paid to do this. - Rules for programming: 1. Get it working, right? 2. Get it working right. - Things I've learned about multithreaded programming: 123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt rhheiianndgge dwi hnpi rctohhg eri aslm omscitanalgt iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb .ee^Nr waicscee snsoetd 'aotb jtehcet -slaomcea lt'il m^Ne from two or more threads ******************************************************