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 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 ]