The mysql commandline client has a --xml (-X) option which ensures that the response to any command is emitted in XML format. This makes the inperpretation of access to MySQL databases from within XML applications very much easier. Are there any plans to implement such an option in SQLite? If not, can this post please be taken as a feature proposal? P
The SQLite command-line tool already has an -html flag, that causes the output to appear as an HTML table. I put that feature in on 2000-05-31 - over two decades ago - and in all that time, I'm not sure it has ever been used.
O wow. thank you. Never knew that. Does it output well-formed HTML (ie can it be used in a pipeline with XML software?) I'll have to find an SQLite database I can try it on.