SQLite Forum

Support for Markdown formatted table output from a query
There is a prototype for three new output modes for the SQLite CLI on trunk.
New modes are:

   *  JSON
   *  markdown
   *  table (looks like MySQL output)

The JSON output seems to work well since JSON is a well-defined format.
The other two modes are in limbo, though.  Issues include:

  1.  How to display BLOB values
  2.  How to distinguish between NULL and the four-character string 'NULL'
  3.  How to display strings with special characters like \\n
  4.  For markdown mode, should it escape characters that have
      special meaning to markdown, like \|, \[, \', and \*

Even thought the table and markdown modes are currently on trunk, they
might not survive there until the next release.