Hacker News new | ask | show | jobs
by nabla9 2086 days ago
Both sqlite and postgresql have options where you can change query result format into html. I think many others have too.
1 comments

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.