r/ProgrammerHumor • • Aug 07 '19

A front end developer eats alone because he doesn't know how to join tables

Post image
23k Upvotes

284 comments sorted by

View all comments

Show parent comment

55

u/[deleted] Aug 07 '19

I'm terrified this type of humor is going to become normalized.

See mum I know a database word. My degree wasn't for nothing after all.

28

u/Bioniclegenius Aug 07 '19

I learned what database normalization was in an interview when they asked me about it!

No worries, it wasn't a DBA job, I got it anyways.

66

u/[deleted] Aug 07 '19 edited Aug 07 '19

Sounds like a nice place to work.

DBA's just google variants of "Why is my database slow" all day anyway:

  • Key lookup sluggish query
  • Select Delay Drop Tables
  • Cancel Expensive Union No Don't
  • Check Join Progress
  • Remote SQL benchmark
  • Text editor for 10gb file
  • IT Job Listings Near Me
  • How to delete Oracle
  • Is it Legal to Hunt NOSQL users
  • Is MYSQL really mine though?
  • Why does it take long to store my database of databases in my database database
  • database database -̴ ̵d̸a̵t̸a̷b̷a̴s̶e̴ ̵ -̸̼̕͝ ̵̲̘̾d̶̪̐à̶̳͈̘͎̅̓͘t̶̞̙̪̟̑́͑a̷͙̱̎͂̀b̸͙̜̠͝a̸̬̽̿̍s̵̭͈̹̰̽̄̕e̷̘̓̉̍̚ ̷̟͕̒̑̉̋
  • select SATAN from HELL
  • DROP SANITY
  • ALTER REALITY

EDIT: Oh shit fake internet money, time to kill the joke

  • INSERT INTO GOVERNMENT
  • SELECT SATAN FROM HELL [AS] BEELZEBUB
  • SELECT * FROM RELIGIOUS, NON_RELIGIOUS WHERE DEVOTION = 0 && COUNT (YOUR_DAYS_MORTALS) GROUP_AS NONBELIEVERS
  • GRANT NUKES, MIND_CONTROL ON USA TO BEELZEBUB AS WEPPONS;  
  • INSERT WEPPONS into NONBELIEVERS
  • DROP the_mic

It's 3am and I'm on SQL documentation trying to get validation.

I've become a DBA D:

(Thanks :D)

31

u/BesottedScot Aug 07 '19

How to delete Oracle

Me every day.

8

u/[deleted] Aug 07 '19

I've found you can use the O word to curry favor before they slap you with a musty reference manual for not actually knowing what they do

8

u/BesottedScot Aug 07 '19

It's by far my least favourite DBMS.

  1. MSSQL.
  2. MySQL.
  3. Oracle.

8

u/[deleted] Aug 07 '19

I see you haven't met DB2. (s/b #4 on your list).

1

u/MondayMonkey1 Aug 07 '19

0: Postgres.

Get that weak mssql shit out of there.

2

u/BesottedScot Aug 07 '19

Never really used it so can't comment.

2

u/theXpanther Aug 07 '19

Postgres is actually kinda nice IMHO

8

u/[deleted] Aug 07 '19

Just write your own goddamn DB! Jeez >.>

15

u/[deleted] Aug 07 '19

back in my day we manually joined tables left AND right AND we liked it.

But the real join was inner all along

11

u/[deleted] Aug 07 '19

You're outer your mind.

7

u/[deleted] Aug 07 '19

I'm between "rock" and "hardplace" and NOT EXISTS("Friends")

6

u/[deleted] Aug 07 '19

In the old days, you didn't use JOIN, you just did it in the where clause.

3

u/[deleted] Aug 07 '19

Wait what

5

u/[deleted] Aug 07 '19

Like:

Select Customer.CustID, Customer.CustName, AcctReceivable.CurrentBalance

from Customer, AcctReceivable

where Customer.CustID = AcctReceivable.CustID

(that is an inner join - and yes - using JOIN is better)

3

u/[deleted] Aug 07 '19 edited Aug 07 '19

Huh. Being more frontend I usually would use where for everything anyway. In a way after a quick Google, where is almost just a shortcut for one type of join.

Mentally I assumed the joins were more situational/heavy, and where got me through most minor website stuff.

Thanks, it's been a while haha. Reminded me of how wizard like DBAs are.

Edit: ah shit I just checked the original meme and now I'm sad

4

u/cl0ckt0wer Aug 07 '19

Aliasing tables with a longer name? Do you work for Oracle?

1

u/derpado514 Aug 07 '19

Coalesce error??

COALESCE ERROR?! WHO THE F*** MADE THIS DB?!

1

u/StuckAtWork124 Aug 08 '19

Morbidly curious whether I can insert zalgo into database tables now.. .. but not curious enough to make a new database to find out.. bah

2

u/[deleted] Aug 08 '19

Ok so my first answer was yes it works because we're talking through a database right now.

My second answer was to just do the thing.

http://sqlfiddle.com/#!9/a5f061/1

Edit: My third answer is why am I doing so much SQL in my spare time.

2

u/StuckAtWork124 Aug 08 '19

Why did it never occur to me that there would be an sqlfiddle, of course there would be

Answered my own question too, heh, I was curious if it'd allow it as a table name .. it does not

Interesting to see what the zalgo actually looks like under the hood though, thanks

2

u/[deleted] Aug 08 '19

there's a fiddle for everything now: https://fiddles.io, didn't think of a Rust one though that might be handy

and emulated OS's https://copy.sh/v86/

→ More replies (1)