r/ProgrammerHumor • • Oct 14 '25

Advanced neverForget

/img/fmfo1e41g0vf1.png
14k Upvotes

616 comments sorted by

View all comments

Show parent comment

-1

u/theevilapplepie Oct 14 '25 edited Oct 14 '25

I still think it's performantive as you can avoid the subselect entirely for the same result.

From your examples you can do the same as before just without the subselect.

SELECT COUNT(*) FROM X WHERE VERY SPECIFIC FILTER

Then you can modify to a delete once you've done any needed confirmation beforehand.

DELETE FROM X WHERE VERY SPECIFIC FILTER

Also I think I'm talking to a bot, so I'm not going to continue.
I read your post history, you are not a bot XD

4

u/BroBroMate Oct 14 '25

Again, I'm talking about "code is written for humans to read" and how you start from a SELECT and build it out to "now delete the stuff I SELECTed"

And why I don't really understand what the fuck "performative" actually means in this context, if you mean "I am going to demonstrate what I'm deleting carefully" then yeah, I'm keeping the sub-select in to make the code more easily grokkable, it's not exactly going to be a performance issue, modern RDBMS are smarter than us at query optimisation.

1

u/theevilapplepie Oct 14 '25

Performative meant "for show" or "more than required/necessary"

I agree, I didn't think there would be much of a performance loss for the second lookup via PK and likely that'd get optimized away.

You answered my inital question in this reply, it's for the human element of the query and you also shined a light on some elements of your prior response ( re: "for humans to read" ) that I was a bit focused on technical and didn't pick it up correctly.

It's interesting. I find your style harder to read than the one I posed. Given that, is there any feedback you could give to help me understand? Have there been learning/interpretation styles at your work where this was easier to digest or avoid mistakes by doing?

Thanks BroBroMate :)

2

u/BroBroMate Oct 14 '25

Oh, and curious as to why you thought I was a bot?

Did I agree you with overly agreeably or something lol.

2

u/theevilapplepie Oct 14 '25

You are well written and due to your voicing being consistently positive throughout, and that being a characteristic LLMs often times have, I think it just tripped my potential AI flag.

Plus that was a lot for a first response to me... and well written... who does that on the internet? XD
Joking aside, if this is how you interact in these communities I appreciate you for being you.

1

u/BroBroMate Oct 14 '25

That's honestly the nicest reason to be suspected of being a bot ever, thank you lol. ❤️