News for hackers. Stuff that matters.

A comment on Learn Postgres at the Playground – Postgres compiled to WASM running in browser. Parent comment

Re:Learn Postgres at the Playground – Postgres compiled to W... by dotancohen on Wednesday August 17, 2022 @04:47PM (#32501487)
The reason that I reach for MySQL when introducing people to SQL is the formatted output, with nice tables and column names. Is there a simple way to get similar output with SQLite?
[ Parent | on HN ]
Re:Learn Postgres at the Playground – Postgres compiled to W... by josephg on Wednesday August 17, 2022 @05:21PM (#32501888)
Yep! Just set sqlite into table mode:

    sqlite> .mode table
    sqlite> select * from example;
    +-----+----------+
    | id  |   foo    |
    +-----+----------+
    | 123 | afsd     |
    +-----+----------+
SQLite also has CSV, JSON, HTML and markdown modes - which is pretty neat!
[ Parent | on HN ]
Re:Learn Postgres at the Playground – Postgres compiled to W... by dotancohen on Thursday August 18, 2022 @12:06AM (#32505137)
Thank you!
[ Parent | on HN ]