SQLite Forum

XML output

XML output

(1) By frisket on 2021-02-19 21:53:29 [source]

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?


(2) By Richard Hipp (drh) on 2021-02-20 00:16:45 in reply to 1 [link] [source]

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.

(3) By frisket on 2021-02-20 10:00:39 in reply to 2 [link] [source]

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.

(4.1) Originally by frisket with edits by Richard Hipp (drh) on 2021-02-20 13:06:35 from 4.0 in reply to 2 [link] [source]

OK, tested that. Works fine, thanks, but it has no enclosing <table>...</table> just the TR rows, but easy enough to script around.