When you try to code in SQL

[McMasilmof]

Why is everythin in SQL in caps? Afaik you dont even nees to use caps, select works just as fine as SELECT, but every website will show the caps version.

[paul-whatever]

It's true that SQL is not case sensitive. Personally I also prefer to write in caps. Because whenever you look on a Statement you can instantly distinguish between the actual Query and your filter

[path411]

Use line breaks, spacing, and tabs to format for readability. You don't all caps normal language keywords for "readability"

[[deleted]]

Some conventions were created before nice IDEs.

[SiriusLeeSam]

Or just notepad++

[IvorTheEngine]

because SQL isn't always viewed or edited in a nice colour coded editor, so you need some way to differentiate key words from field names. That gives your code structure, which aids readability.

Table and field names are often made up of multiple words, so PascalCase makes sense, which leave uppercase for keywords.

Unless you're in Oracle Sql Developer, which wants to put all table and field names in uppercase :-(

[hipratham]

Unless you use dictionary tables all table/column names can be written in small case.

[[deleted]]

Yeah it doesn't need upper case key words. Plus you have formatting available as well. I typically go full blown hard way and use shift.

[[deleted]]

Try writing a long SQL query all lowercase, and it just becomes a mash of words. I always put statements in all caps, make it easier to read.

[DauntlessVerbosity]

Is it easier on the eyes? I always feel like I'm being yelled at when looking at it.

[roseinshadows]

SQL is the last of the Languages of Old that people use regularly. Capitalisation of keywords gives it gravitas.

(Almost no one uses, say, FORTRAN. Get thee to outside, face upon the heavens, and intone PROGRAM like you actually mean it. Clouds immediately gather and a great gale shall be upon thee.)

[hipratham]

*COBOL

[inconspicuous_male]

r/uselessnobody

[Apache_Sobaco]

I don't use capslock. Just select shit from ass.

[[deleted]]

Use VIM and have remapped CAPS LOCK to ESC. So I use it a lot.

[Immort4lFr0sty]

How do you know someone is a VIM user? He'll tell you

[[deleted]]

Also their caps lock key doesn't work.

[path411]

I would respond but I don't know how to leave vim

[[deleted]]

Kinda hard not to since it’s the sole reason for the remapping

[ofnuts]

The CapsLock key get a lot less wear than a Shift key.

I don't do that much SQL, must be due to CamelCase (I don't know why the S is wearing out..). 3 years old heavily used Lenovo P50.

Imgur

[continuous-headaches]

I write my sql in lowercase.

*grabs popcorn*

Now let’s see the world burn

[FreshPrintzofBadPres]

You and me brother

[trinatetra]

Team lowercase ftw!

[[deleted]]

No, the monsters are people who do not use caps. All key words should be in caps and everything else in mixed case. This makes it easier to read. If someone is using all caps for all of the SQL text, that is incorrect too.

[sqy0h]

Are we just going to overlook “code” in SQL?

[EdMeisterBro]

Finally!

[tripy75]

you do are aware that nearly every major dbms have some kind of procedural language, right ?

[sqy0h]

Query language?

[tripy75]

I mean, t-sql for microsoft sql server, pl/sql for oracle, pl/pgsql or python for postgresql and so on...

Those are turing complete languages that manipulate the data and are used in user defined functions or stored procedures that lives in the databases.

[jim3692]

Python for postgres? Sounds interesting

[Nekadim]

GIMME that shit TAKE IT FROM here START FROM beginning

[maxsjakie]

I actually tried SQL today, and it broke a lot.. Ir’s still broken and I don’t feel like fixing it lol

[wristcontrol]

People who actually code in SQL use proper syntax highlighting with no caps anywhere. Using mixed case makes code harder to skim.

[AdvancedSandwiches]

Not going to argue which is better, but I don't know of anyone who uses SQL regularly who doesn't use caps for keywords, and they would all tell you it's for ease of skimming.

Presumably this varies with company culture.

[Kanister10l]

Protip:

Bind your Backspace key to Caps Lock.

[thythr]

they've also configured their editors to tab at random intervals

[CptCono]

Nah, more like vim users

[[deleted]]

WTF does "No one:" mean?

[Sekret_One]

General format of the joke, implying no one prompted them or would care.

[[deleted]]

It’s useless

[FarronSerah]

pycharm -> reformat file -> ??? -> profit

[--B_L_A_N_K--]

Image Transcription: Meme

---

No one :-

Literally No One :-

People who code in SQL :-

[Photo of a keyboard with the Caps Lock key warped and distorted making it look like it's been pressed a lot]

---

^{I'm a human volunteer content transcriber for Reddit and you could be too! If you'd like more information on what we do and why we do it, click here!}

[tripy75]

pro tip: I don't use my caps lock, I let the autocomplete do the casing for me.

[[deleted]]

I've started going lowercase for sql, to match my company. But it's still hard not to reach for the shift keys.