this post was submitted on 19 Oct 2023
3 points (80.0% liked)

Programmer Humor

42376 readers
79 users here now

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

Rules:

founded 6 years ago
MODERATORS
 
top 4 comments
sorted by: hot top controversial new old
[–] xmunk@sh.itjust.works 2 points 2 years ago

Speaking as a Senior Dev specialized in database access and design... you don't have to use all caps - SQL is actually case agnostic.

But... but my fucking eyes man. I'm old, if your branch doesn't have control keywords in all caps I'm going to take it out back and ol' yeller it.

There are few hills I'll die on but all caps SQL and singular table names are two of them.

[–] bappity@lemmy.world 1 points 2 years ago

UM ACKSHULLY SQL ISN'T CASE SENSITIVE ☝️🤓

[–] rwhitisissle@lemmy.ml 1 points 2 years ago* (last edited 2 years ago) (1 children)

The phrase "SQL programmers" is so fucking weird. SQL isn't a programming language. It's a query language. You don't "program" things with SQL. You utilize SQL as a component of programs for data insertion and lookup, but the actual logic of execution is done in a programming language. Unless you're doing Oracle PL/SQL, in which case why are you giving money to Oracle?

Edit: Damn, this comment made people mad.

[–] KarmaPolice@lemmy.world 1 points 2 years ago

Most database engines support stored procedures. You don't need to give money to oracle, you can give it to Microsoft instead.