overview for Moops

Is there nothing sacred in this forsaken world anymore? in c/memes

[–] Moops 40 points 1 day ago* (last edited 1 day ago)

I just experienced this. The box said they'd be just as good. They were not just as good.

The wonders of how the human body works in c/lemmyshitpost

[–] Moops 17 points 3 days ago

Hi straight. I'm narrow.

Don’t Look Up director says ‘half a billion people’ have now seen film despite critics in c/[email protected]

[–] Moops 1 points 1 week ago* (last edited 1 week ago)

It seems like critics are turning more and more inward, and what they appreciate is increasingly esoteric. So the stuff they like is less accessible to the unwashed masses like myself because if you're not staying up to date on the latest and greatest trends in the medium, it doesn't make sense why they rate something so highly.

Don’t Look Up director says ‘half a billion people’ have now seen film despite critics in c/[email protected]

[–] Moops 21 points 1 week ago (4 children)

Yeah audience scores are my jam. Critics have failed me time and time again.

How do you make proper "I am interested in you." eye contact? in c/asklemmy

[–] Moops 3 points 3 weeks ago

The trick is to never look away. Stare till they notice, then keep staring. Have to get up to use the restroom? Maintain eye contact as long as possible and reestablish it the moment you're back in sight. If they get up, the responsibility to maintain that eye contact is on you. Make sure to stay within eyesight, following them if necessary. This is your chance, we're rooting for you!

Newborns are being left in dumpsters in Texas, but Republicans don't seem to care in c/politics

[–] Moops 33 points 3 weeks ago

This is consistent with their pro fetal-life platform.

Ukraine: Zelensky condemns "inhumane" Russia Christmas Day attack in c/world

[–] Moops -5 points 1 month ago (5 children)

I didn't see your comment till just now. Sorry you got down voted. People are dumb for down voting you because you asked a question. I saw an answer, so have an upvote friend :)

Ukraine: Zelensky condemns "inhumane" Russia Christmas Day attack in c/world

[–] Moops 74 points 1 month ago (12 children)

Sure, but whataboutism doesn't change the gravity if this situation.

That perfect Christmas gift - a picture to hang on your wall commenorating when you wore that classy orange jump suit in c/lemmyshitpost

Buddy baka in c/lemmyshitpost

[–] Moops 2 points 1 month ago

Chicken dinner right here boys. Gotta be it.

Against the rules to say Luigi is innocent on c/[email protected] in c/[email protected]

[–] Moops 4 points 1 month ago

Yup. News is the only instance I've blocked cause of that kind of nonsense. Luckily we got choices and can easily leave poorly-run communities without leaving the whole 'verse.

Should one give money directly to homeless people? in c/[email protected]

[–] Moops 29 points 2 months ago (1 children)

I personally do not, but I think it's a personal decision. I have a background in working for homeless non-profits. If you have a desire to really help and be part of moving towards a solution, find a local group and donate and/or volunteer with them.

The reality of handing money to someone is at best it's a band-aid, and more often you're just buying that night's substance of choice. No judgement there, if I was homeless and likely not receiving needed medical and mental health treatment, I'd be high and drunk as often as I could too. Hell, I'm high as often as I can be now. Nevertheless though, I feel comfortable choosing not to participate by handing money when asked and I don't begrudge anyone who does.

7

What are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... ) (self.sql)

submitted 6 months ago* (last edited 6 months ago) by Moops to c/sql

2 comments fedilink

I had an interesting conversation at work where someone questioned my use of DENSE_RANK and suggested I use LAST_VALUE. We had a good conversation about it, but ultimately agreed to disagree about the specific scenario. My code was accurate with no performance issues warranting a rewrite. My feeling was the person I was talking too was less familiar with DENSE_RANK and so favored LAST_VALUE. I get preference, I have my own, but I try to be aware of what's preference vs. what's technically superior.

I'm curious about people's thoughts on when to use LAST_VALUE() vs MAX() KEEP(DENSE_RANK LAST ORDER BY ). To my mind, both solve a similar problem. I lean towards DENSE_RANK largely out of preference due to the syntax being shorter (literally just less characters to type), and I also like that since DENSE_RANK is an aggregate function it outputs distinct results without needing to use the DISTINCT keyword. I haven't intentionally run tests comparing the two, but anecdotally I've never noticed a performance difference between the two when writing comparable queries.

Surprisingly I couldn't really find any detailed articles or discussions online comparing these two functions and I'm curious what thoughts are out there in the wild.

20

Have any of y'all noticed you're generally in a better mood after moving to the fediverse? (self.asklemmy)

submitted 2 years ago* (last edited 2 years ago) by Moops to c/asklemmy

5 comments fedilink

I've been in a great mood for the last week. Like, so much so I've even noticed a couple times and thought to myself "wow, I'm in a really positive mood." I've long minimized my use of social media and recently left that other site, interacting exclusively on Lemmy for my online community interactions.

I noticed my attitude of always being on guard whenever I say/comment/post anything here or IRL, expecting someone to roll through and light me up, has diminished and I'm generally feeling more confident and enjoying interactions both here but also IRL

I'm sure there's more to it than simply an online community change but holy shit. Seeing the effect ebb into my real life is amazing. You always hear about the negative impacts of social media on mental health but to experience it in real time is something else.

13

Had to check that butt out one last time before bed. (lemmy.world)

submitted 2 years ago* (last edited 2 years ago) by Moops to c/smoking

0 comments fedilink

There she is, looking all fine. Had to get one more peek before calling it a night a little early. We have a hot date in the morning.