7 ms·
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 comp
by josephg 4y ago
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.
- dotancohen 4y agoThe 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?
- josephg 4y agoYep! 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!
- dotancohen 4y agoThank you!