Hacker News Reader

Comment by nabla9 | Hacker News Reader

Both sqlite and postgresql have options where you can change query result format into html. I think many others have too.

View on HN

They have an option to change query result into JSON, not HTML AFAIK (although nothing stops you to do that with strings). You still need to provide UI for json via some javascript frameworks such as Vue.js.

There is an option to change query result to HTML in both. I checked.

You are wrong. Give us reference for native html function in postgres and not string massage.

https://www.sqlite.org/cli.html#dotmode

I have just checked it via cli:

    sqlite3 -header -html foo.db

That is feature of CLI tool, not sqlite.

From command line use

     psql -H

Alternatively

     \pset format html

Again, feature of CLI tool not postgresql.

Reply on news.ycombinator.com