News for hackers. Stuff that matters.

A comment on AWS Babelfish: The Elephant in the PostgreSQL Room?. Parent comment

Re:AWS Babelfish: The Elephant in the PostgreSQL Room? by katnegermis on Friday February 12, 2021 @03:44PM (#26118335)
I really love using dbeaver[1] as a Postgres IDE. It requires a small bit of configuration for me to use it (why are the defaults to automatically lowercase all of my SQL?!). Other than that it's excellent!

[1]: https://dbeaver.io/

[ Parent | on HN ]
Re:AWS Babelfish: The Elephant in the PostgreSQL Room? by dragonwriter on Friday February 12, 2021 @09:57PM (#26120998)
> why are the defaults to automatically lowercase all of my SQL?

Because yelling at the database server doesn't make it work better, and just makes uglier code.

[ Parent | on HN ]
Re:AWS Babelfish: The Elephant in the PostgreSQL Room? by e12e on Saturday February 13, 2021 @10:55AM (#26124297)
It's a surprising default - for better or worse history made the convention that SQL KEYWORDS be uppercase (when pretty printed). I assume it stems from case being irrelevant and a time of green screens and monochrome printouts - but it's still the most common formatting/presentation of sql?
[ Parent | on HN ]
Re:AWS Babelfish: The Elephant in the PostgreSQL Room? by rbanffy on Saturday February 13, 2021 @05:07AM (#26122644)
Uppercasing keywords makes it easier to read the code. Apple's Pascal tooling did that, IIRC.
[ Parent | on HN ]
Re:AWS Babelfish: The Elephant in the PostgreSQL Room? by Quarrelsome on Friday February 12, 2021 @04:39PM (#26118868)
because fuck the shift key. RSI sufferers unite!

but in all seriousness, I don't know.

[ Parent | on HN ]