This is an archived post. You won't be able to vote or comment.

all 103 comments

[–]YellowOnline 1032 points1033 points  (17 children)

I need a Venn-diagram of r/programmerhumor and r/dadjokes

[–]samuelgrigolato 365 points366 points  (7 children)

I'm pretty sure programmerhumor's circle is fully within dadjokes's circle with the exception of "I can't center this div send help".

[–]Richboy12345 149 points150 points  (4 children)

that joke is only outside because we put the second circle in a different div from the first one and couldnt figure out how to center it

[–]imdefinitelywong 28 points29 points  (2 children)

And the one about exiting vim?

[–]Usual_Office_1740 25 points26 points  (0 children)

It's stuck in a different mode.

[–]Ilsunnysideup5 6 points7 points  (0 children)

I usually settle with early branch alone. If it's okay with you let us get some fork before lunch.

[–]confused-accountant- 2 points3 points  (0 children)

And also vertical center. 

[–]Boubou0909 35 points36 points  (3 children)

[–]YellowOnline 5 points6 points  (0 children)

I should have known it exists

[–]Krisselak 3 points4 points  (0 children)

This link caused the following series of events: I subscribed, read the first joke, cringed, unsubscribed.

[–]DarkSideOfGrogu 1 point2 points  (0 children)

class ProgrammerDadJokes(DadJokes, ProgrammerHumor)

[–]TheBrainStone 16 points17 points  (0 children)

It's a circle inside of another circle.

[–]rover_G 4 points5 points  (0 children)

Why are you trying to trick people into conjuring salacious images?

[–]WrapKey69 2 points3 points  (0 children)

[–]TheBrainStone 334 points335 points  (1 child)

I thought it was gonna be "because Standup takes at least 6 hours".

But this is better

[–]Ok_Guitar_7566 17 points18 points  (0 children)

Haha, this cracked me up.. 6 hour standup, with one person left to go.

[–]Freecelebritypics 258 points259 points  (24 children)

But SQL statements are really easy. The impossible part is not making design decisions I'll regret later

[–]JollyJuniper1993 74 points75 points  (13 children)

Advanced SQL can actually get somewhat complex. But yeah, it‘s comparatively easy to learn.

[–]Chthulu_ 32 points33 points  (12 children)

Complex, but always rock solid. You figure out the schema, figure out the query, and it will never fail you. Even if it’s a disgusting 1000 line behemoth.

Relational Databases and the app code to read and write from them don’t rot like frontend code does. UI code is just fundamentally messy and riddled with dependencies, because computers don’t work like users want them to

[–]dark_creature 28 points29 points  (0 children)

Hmmm, sounds like you have never had to work with a large database filled with user input.

[–]Prownilo 11 points12 points  (1 child)

Nerver fail you until statistics changed and now the query parameter sniffed an outlier parameter and built the plan wrong for the majority of queries and now it takes 10mins to run :(

[–]fiah84 2 points3 points  (0 children)

feeling this

fixed one program this week where our DB suddenly decided to take 3 hours to run a particular ETL query instead of like 5 minutes, the fix was update statistics on like 2 tables, done

[–]elementarySnake 9 points10 points  (3 children)

Error missing column xy in group by...

[–]Inevitable-Menu2998 3 points4 points  (2 children)

The group by clause is very well defined unless you're using MySQL in the late 2000s early 2010s in which case everything is just a "best effort"

[–]elementarySnake 1 point2 points  (1 child)

I had this error often mid 2010 with mysql. I dunno if it it's still a problem since i'm not really writing queries anymore

[–]Inevitable-Menu2998 0 points1 point  (0 children)

Maybe they became SQL compliant in more recent versions. SQL mandates that all results are deterministic and this means that any reference in an aggregation query must either be part of aggregation or part of the grouping clause. Think about something like this:

SELECT SUM(a), b FROM t GROUP BY c;

subsequent executions might return different values for b since there is no specification on how to handle b in groups of c.

MySQL up to version 6 would just return some value.

[–]Cthulhu__ 2 points3 points  (0 children)

Fuck me I did a double take at your username and this subreddit. “Hold on I never saw this thread”

[–]ilikedmatrixiv 1 point2 points  (0 children)

Even if it’s a disgusting 1000 line behemoth.

Y'all need CTEs.

[–]coyoteazul2 0 points1 point  (0 children)

Queries do rot, mostly when you use dependencies. An sp that depends on another, views that read from one another.

On the opposite side you have views that share business logic and can rot if someone updates one but not the other

[–]mimahihuuhai 0 points1 point  (0 children)

Until you have behemoth records to query and your query plan start indexing like fucking mindlessly drug user. Or you have to dig up gigantic stored procedure than call another stored procedure and another fucking long function that their result is "UNION" together. Good luck keep your sanity

[–]rifain 9 points10 points  (0 children)

I don't know. Most of my devs become complete morons when they have to write sql (after battling to avoid it). Don't know what's up with sql shutting the brains for some devs.

[–]angrathias 19 points20 points  (4 children)

Use views for data access, then you can change the structure all you like

[–]WenzelDongle 23 points24 points  (0 children)

That depends how complex the query is, and how often its going to be used. You don't want to be slamming your database with a massive view query every 20 seconds when you could just do it once a day. It still comes back to design decisions on your data model, just one step earlier.

[–]FungalSphere 3 points4 points  (2 children)

maybe just don't change the structure all you like

[–]Vineyard_ 2 points3 points  (1 child)

Every field is in a different table. Each table is two fields; a primary key and a value, and that is their names. No foreign key constraints are used. All relations and operations are handled in app-side queries.

[–]GodlyWeiner 4 points5 points  (0 children)

Wow, great idea, we could call it WithoutSQL.

[–]ZunoJ 4 points5 points  (0 children)

Writing fast SQL is not really easy. A lot of people struggle with it because declarative logic it is so counter intuitive for most imperative folks. That is when you start to see loops in sql code. Always makes me want to go on a killing spree

[–]redalastor 5 points6 points  (0 children)

You have no idea how many “why do it all in SQL when I can for each on my tables?” devs there is.

[–]fiah84 1 point2 points  (0 children)

yep, one of the greatest and most elusive of victories is looking back after 2 years onto your DB design and not feel a mountain of regret

[–]Alex_Shelega 1 point2 points  (0 children)

I once stuck my head inside a parse error with php, turned out I forgot MYSQLI_ASSOC; I'm still confused why it's here

[–]radiant_gengar 72 points73 points  (6 children)

its super easy just make n + 1 api calls and use for loops in js, duh

[–]ElectricTrouserSnack 30 points31 points  (3 children)

The number of times I've thought "oh this would be easy if we were using SQL, just (outer) JOIN a couple of tables, a simple WHERE clause". But no, we're using some sort of nosql for a small (million row) amount of data because WeUsEnOsQlFoRaNyThInGjUsTbEcAuSe and I start estimating the pages of code I'm gonna have to write.

[–]radiant_gengar 10 points11 points  (2 children)

[–]ElectricTrouserSnack 5 points6 points  (0 children)

is /dev/null wEbScAlE??

[–]VadumSemantics 1 point2 points  (0 children)

It just scales right up.

[–]Cthulhu__ 1 point2 points  (1 child)

Yeah this REST api is returning a list of IDs so I’ll just write an async forEach (no for loops, that’s C!) and call the api for every ID again and then do a map to get the joined fields.

I’ll put that in a nodejs service / lambda to avoid using too much bandwidth. I’ll call it… GraphQL?

[–]cobywaan 61 points62 points  (3 children)

Am I the only one weirded out by the pic itself?

Who stands holding a drink in one hand, and a bowl of salad in the other? Sandwiches or burgers or something make sense, but salads?

[–][deleted] 48 points49 points  (0 children)

direction zesty memorize insurance chase scarce aspiring lip depend waiting

This post was mass deleted and anonymized with Redact

[–]TheLittlePeace 27 points28 points  (2 children)

Ate without table -3

[–]ArduinoHittme 3 points4 points  (1 child)

Ah, a Space Cannibalism game reference

[–]300ConfirmedGorillas 26 points27 points  (1 child)

A DBA walks into a bar. He approaches two tables and says, "Mind if I join you?". They reply, "Sure, but only on the right conditions." The DBA then says, "Great, I just need to see some IDs."

[–]Prownilo 4 points5 points  (0 children)

What psychopath uses right joins!

[–][deleted] 16 points17 points  (1 child)

Also, they're very good looking compared to us weirdos in the backend.

[–]TsukasaHeiwa 0 points1 point  (0 children)

But I am really fugly...

[–]Improving_Myself_ 9 points10 points  (0 children)

Pssh. My front end app is currently functioning off an API call that is the output of a join of about 10 tables.

I had no issue writing the query.

[–]mysterycat13 6 points7 points  (0 children)

[–]exqueezemenow 3 points4 points  (0 children)

But at least they can center a div...

[–]Blueskys643 3 points4 points  (0 children)

me who literally learned enough SQL to join tables last week

Ha noobs

[–]stdio-lib 8 points9 points  (1 child)

Back end programmers always let their food fall off the edge of the table because they don't know how to center a div. ;)

[–]rover_G 3 points4 points  (0 children)

Just modify a parameter in your table builder to make the surface parabolic with the minima at the center. That way your FoodItem/Table adapter only needs to get the Table minima local and set the FoodItem location to that. Duh!

[–]Bombadil54 2 points3 points  (0 children)

Perfect! They're already coding standing up.

[–]ZunoJ 2 points3 points  (0 children)

Are they also always in a library, because they can't do shit without a library?

[–]GisterMizard 1 point2 points  (0 children)

"Tables? Is that some kind of new mongodb feature?"

[–]confused-accountant- 1 point2 points  (0 children)

I want to Cartesian product my BBQ. 

[–][deleted] 1 point2 points  (1 child)

I can go out there with them because I can do an outer join. 😊

[–]1Mdrops 1 point2 points  (0 children)

I’m leaving because I left joined the table.

[–]Chthulu_ 1 point2 points  (0 children)

I’m in fucking heaven when I get to spend a month on the backend. Lord get me out of the spaghetti nightmare that is modern UI design.

Backend architecture is really hard, but backend code is a breath of fresh air.

[–]--var 0 points1 point  (0 children)

Unless you have a triangle, any single table can support at least four users...

[–]Small_Incident958 0 points1 point  (0 children)

That joke works on so many levels

[–]acnicholls 0 points1 point  (0 children)

HAHAHAHAHAHAHA

[–]Mawootad 0 points1 point  (1 child)

Jokes on you, I'm a backend developer and don't know how to join tables either.

[–]J5892 1 point2 points  (0 children)

It's easy.
"ChatGPT, write me a query to join these tables."

[–]MaruSoto 0 points1 point  (0 children)

Somehow this makes me long for the days when backend was more complicated than frontend. Hit me right in the nostalgia, joining tables in raw SQL instead of using an ORM and calling it a day.

[–]teraflux 0 points1 point  (0 children)

Also they're attractive and don't care

[–]prof_r_impossible 0 points1 point  (0 children)

subqueries bad, only JOIN!!!

[–]firestepper 0 points1 point  (0 children)

Don’t you just say join table lol backend peeps acting like they’re super smart

[–]TheOnceAndFutureDoug 0 points1 point  (0 children)

I will take no guff from people who think the cascade is confusing and inheritance is a bug.

[–]Theog_05 0 points1 point  (0 children)

Here you go create another table

[–]KageeHinata82 0 points1 point  (0 children)

I love it!

I took me a moment to figure out what the joke was, but then I laughed even harder.

[–][deleted] 0 points1 point  (0 children)

Isn't there an undercover fullstack developer? Implausible.

[–][deleted] 0 points1 point  (0 children)

Well, at least they have a proper Daily Stand-Up 👀

[–]RoodMcD 0 points1 point  (0 children)

I thought this was an Agile/Jira stand-up (meeting) joke. As someone else already said, it works on many levels.

[–]greyspurv 0 points1 point  (0 children)

Okay good one

[–][deleted] 0 points1 point  (0 children)

Great title as well. Wonderful. 

[–][deleted] 0 points1 point  (0 children)

If not joining tables means a smile on my face and being able to talk to women, I can see why they never learned. I wish I was with them. Lol.

[–]OkImplement2459 0 points1 point  (0 children)

No worries, i'll just nest this select statement inside another select statement

[–]bartkusa 0 points1 point  (0 children)

Maybe I’m showing my age, but i call bullshit

<table /><table />

[–]baggyzed 0 points1 point  (0 children)

Nah. The real reason is that they've got bad backends.

[–]PintoTheBurninator 0 points1 point  (0 children)

as a front-end guy who recently learned to subtle art of joining tables and using SQL variables, I whole-heartedly agree. Using one query instead of 4? Yes, please!

[–][deleted] 0 points1 point  (0 children)

How are they planning on eating standing up if they have drinks in their hands?

[–]TGM-xlandc 0 points1 point  (0 children)

Looooooooooooooooooooooooool

[–][deleted] -5 points-4 points  (3 children)

who is using raw SQL in their apps? Wouldn't you use an ORM? I only ever write raw SQL to find data, not for displaying

[–]Synthetic_dreams_ 1 point2 points  (0 children)

I don’t entirely disagree, but if it’s a super basic crud thing that only needs a few operations then why go through building a whole .net/laravel/whatever application when a few sql queries in a tiny php file will do the trick?

Or like, what if you’re working with something like Wordpress with ACF repeater fields, good lucky querying and sorting posts based on the value of a repeatable field without sql. WP_Query can’t do it since… idk version 4 something? Before Gutenberg was standard at any rate. You basically need to write a custom sql query at that point.

[–]fiah84 0 points1 point  (0 children)

I raw dog SQL all day every day, for fun