What I Wish Someone Told Me About Postgres

Re:What I Wish Someone Told Me About Postgres by MetaWhirledPeas on Tuesday November 12, 2024 @04:37PM (#42119982)

> writing queries with keywords in all caps is an effort to increase legibility for visual pattern matching

Considering most programming languages do just fine without ALL CAPS KEYWORDS I'd say it's a strange effort. I wish SQL didn't insist on being different this way.

I agree with you on prettification though. As long as the repository chooses a prettifier you can view it your way then commit it their way. So that's my advice: always demand prettification for pull requests.

[ Parent | on HN ]

Re:What I Wish Someone Told Me About Postgres by sensanaty on Tuesday November 12, 2024 @05:08PM (#42120312)

I don't write or read SQL too often, but I prefer the ALL_CAPS because it usually lets me know if something is part of the SQL syntax itself or a function or whatever, or if it's referencing a table/column/etc.

Obviously not very foolproof, but automated linters/prettifiers like the one in DataGrip do a good job with this for every query I've ever thrown at it.

[ Parent | on HN ]