Hacker News Reader

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/

View on HN

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

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?

Uppercasing keywords makes it easier to read the code. Apple's Pascal tooling did that, IIRC.

because fuck the shift key. RSI sufferers unite!

but in all seriousness, I don't know.

Reply on news.ycombinator.com