Programmer Humor

32415 readers

788 users here now

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.

founded 5 years ago

MODERATORS

AgreeableLandscape@lemmy.ml

cat_programmer@lemmy.ml

1723

I love it when I have to scream at a computer (lemmy.world)

submitted 1 year ago by tsuica@lemmy.world to c/programmerhumor@lemmy.ml

171 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] xmunk@sh.itjust.works 177 points 1 year ago (53 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.

[–] Nolegjoe@lemmy.world 71 points 1 year ago (36 children)

I'm a sql developer, and I am completely the opposite to you. I will find it incredibly difficult to read when everything is in caps

[–] xmunk@sh.itjust.works 18 points 1 year ago* (last edited 1 year ago) (7 children)

Sorry, to clarify, not everything is in all caps. I'll append my prefered syntax below

WITH foo AS (
    SELECT id, baz.binid
    FROM
            bar
        JOIN baz
            ON bar.id = baz.barid
)
SELECT bin.name, bin.id AS binid
FROM
        foo
    JOIN bin
        foo.binid = bin.id

The above is some dirt simple SQL, when you get into report construction things get very complicated and it pays off to make sure the simple stuff is expressive.

[–] NedDasty@lemmy.world 14 points 1 year ago (2 children)

You indent your JOIN? Why on earth? It lives in the same context as the SELECT.

[–] xmunk@sh.itjust.works 9 points 1 year ago

I've seen both approaches and I think they're both quite reasonable. An indented join is my preference since it makes sub queries more logically indented... but our coding standards allow either approach. We've even got a few people that like

FROM foo
JOIN bar ON foo.id = bar.fooid
JOIN baz ON bar.id = baz.barid

[–] callcc@lemmy.world 6 points 1 year ago (1 children)

Actually not. It's part of the FROM

[–] Stumblinbear@pawb.social 2 points 1 year ago

That double indented from is hurting me

load more comments (4 replies)

load more comments (32 replies)

load more comments (48 replies)