4 ms·

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

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/ https://dbeaver.io/

Quarrelsome 6y ago
because fuck the shift key. RSI sufferers unite! but in all seriousness, I don't know.
dragonwriter 6y ago
> 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.
- rbanffy 6y ago
  Uppercasing keywords makes it easier to read the code. Apple's Pascal tooling did that, IIRC.
- e12e 6y ago
  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?