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.
Practically, you want to capitalise the commands anyway.
It gives your code some gravitas. Always remember that when you’re writing SQL statements you’re speaking Ancient Words of Power.
Does that JavaScript framework that got invented 2 weeks ago by some snot-nosed kid need Words of Power? No. Does the database that has been chugging on for decades upon decades need Words of Power? Yes. Words of Power and all the due respect.
My God, that’s hilarious, thank you for sharing it. I enjoyed “I am like the Statue of Liberty: I accept everyone, even the wretched and the huddled and people who enjoy Haskell.”
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programmerhumor@lemmy.ml
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
Posts must be relevant to programming, programmers, or computer science.
No NSFW content.
Jokes must be in good taste. No hate speech, bigotry, etc.
UM ACKSHULLY SQL ISN’T CASE SENSITIVE ☝️🤓
Please tell that to the git overlords at my work. They won’t approve a merge with even a single unnecessary capitalization.
tRy fAcEbOoK sTyLe!
[Serious question] Is there a difference between “Facebook Style” and “Mocking SpongeBob”?
ClOwNcAsE
I don’t know. I just used the first name that came to mind. :)
abolish capital letters 2k24
I always remap my tab key to ctrl. Where is your god now…
Remapping caps lock to Ctrl I can see (and have done), but Tab…? Do you just indent with the space bar
I never use all caps when I write SQL, not sure why people insist on it so much
It feels important when it’s bold. To the untrained eye, maybe even impressive.
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
The more you look away the bigger the text gets to grab your attention!
Was an Oracle thing. Postgresql is rather on the lowercase side of things…
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.
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
It’s tabs vs spaces for SQL. Notice how I capped.
Yea, but did you pronounce that Essquel or Sequel?
Honestly, when I read your comment, my internal monolog said “Huh, Esckwell? Ohhhhhh”
“Squill”
Squirtle
Squeal
“Squirrel”
There is only one correct way to pronounce it. Everyone who pronounces it the other way is a moron.
What about the third way?
If they’re talking to me? Moron. If they’re talking to someone who pronounces it the other way? Unconventional comedic genius.
Both in the same sentence just to fuck with people
In actuality I randomly switch between them. I am chaotic evil.
deleted by creator
MAKING SQL QUERIES IN CAPITAL LETTERS MAKES DATABASE TO SENSE URGENCY AND RUN FASTER.
Yes, WHY do I write all my SQL statements In all CAPS and why isn’t there a better SQL editor, and why hasn’t SQL evolved more than it has?
Well I like this way, makes it easy to understand and read. My IDE has a good SQL editor and I can see it perfectly and well formatted and colored…
Nobody knows (/s) but you don’t have to write keywords in upper case (for most DB’s default settings anyway).
Yeah… But caps lock is the cruise control for cool. How else am I going to switch between Slack and my editor easily?
You can even write them sarcastically like this:
sElEcT * fRoM dUaL
You have ruined my assumptions of SQL coders. How dare you! /s /dramatic
The mental gymnastics needed to understand joins 😂
It’s basically just a VLOOKUP is how I explain it to my friends who might be familiar with excel but not a real database.
If you know vlookup, you should checkout xlookup. Even more similar, relatively speaking of course. No longer do I have to count my columns
I love this
Technically, SQL is case-insensitive.
Practically, you want to capitalise the commands anyway.
It gives your code some gravitas. Always remember that when you’re writing SQL statements you’re speaking Ancient Words of Power.
Does that JavaScript framework that got invented 2 weeks ago by some snot-nosed kid need Words of Power? No. Does the database that has been chugging on for decades upon decades need Words of Power? Yes. Words of Power and all the due respect.
deleted by creator
Reminds me a bit of Skyrim. You are… the query-born.
This sounds like something James Mickens would write.
My favourite by him: The Night Watch (PDF)
My God, that’s hilarious, thank you for sharing it. I enjoyed “I am like the Statue of Liberty: I accept everyone, even the wretched and the huddled and people who enjoy Haskell.”
Whoops, I accidentally deleted my comment. Here’s the link again for posterity: https://www.usenix.org/system/files/1311_05-08_mickens.pdf
I’m going to print this out and frame it on the wall of my office.
SeLEct uSERnaMe frOm usERs WhErE fiRStnAmE = ‘John’;
COBOL too lol
Theres a dozen of you keeping banking around the world from falling apart lol
Wait, you guys aren’t just writing code and then hitting the FORMAT button?
this is the only right way
THANKS, NOW I DON’T HAVE TO HOLD DOWN THE SHIFT KEY WHEN I TYPE ANYMORE!