Learn Postgres at the Playground – Postgres compiled to WASM running in browser

Re:Learn Postgres at the Playground – Postgres compiled to W... by josephg on Wednesday August 17, 2022 @03:27PM (#32500643)

Being necessary and being exhausting aren't mutually exclusive qualities.

But - why are the steps needed to create a database and setup credentials such a complex, manual process anyway? Why can't all those steps just be automated by a helper script that ships with postgres?

I reach for sqlite whenever I introduce SQL to people because its so much easier to get started with sqlite.

[ Parent | on HN ]

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 ]