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

Programmer Humor

32410 readers
1 users here now

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

Rules:

founded 5 years ago
MODERATORS
 
(page 2) 50 comments
sorted by: hot top controversial new old
[–] pdavis@lemmy.world 4 points 2 years ago (1 children)

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?

load more comments (1 replies)
[–] xmunk@sh.itjust.works 3 points 2 years ago (1 children)

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.

[–] eek2121@lemmy.world 1 points 2 years ago (1 children)

Singular table names? You savage…

[–] xmunk@sh.itjust.works 0 points 2 years ago (1 children)

It's an English literacy thing - we have several non-native English speakers and using only singular avoids making those folks' lives harder. Besides it's really nice to autopilot that categoryid is a foreign key to the category table. It also simplifies always plural words... I haven't yet written CREATE TABLE pants but if I ever do there's zero chance of me creating a pantid.

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

no underscores either? What are we, apes?

load more comments
view more: ‹ prev next ›