this post was submitted on 19 Oct 2023
1726 points (98.8% liked)

Programmer Humor

32570 readers
110 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 11 points 1 year ago (4 children)

I never use all caps when I write SQL, not sure why people insist on it so much

[–] [email protected] 8 points 1 year ago* (last edited 1 year ago)

I write it in lowercase but then the auto-formatter we use at work converts it to uppercase when I save the file.

I love auto formatters. Prettier (the initial version for JS) really popularized the concept. If the coding style is automated where possible (things like tabs vs spaces, tab width, line wrap at 80/100/120 characters, where to put line breaks in long statements, etc), it ensures the entire codebase is consistent, and I can jump between different code bases with different coding styles without having to think too much about it.

[–] [email protected] 2 points 1 year ago

Was an Oracle thing. Postgresql is rather on the lowercase side of things...

[–] [email protected] 2 points 1 year ago* (last edited 1 year ago)

I was taught it when working with Oracle SQL (their certification was not cheap and the exam also not easy)

Personally do what's easiest if it's your own database

[–] [email protected] 1 points 1 year ago (1 children)

It feels important when it's bold. To the untrained eye, maybe even impressive.

[–] [email protected] 3 points 1 year ago (1 children)

I dunno, I don't need it to be important, I need it to work and be readable and, to me, all caps is unreadable

[–] [email protected] 2 points 1 year ago

The more you look away the bigger the text gets to grab your attention!