overview for Moops

Cowboy in c/lemmyshitpost

[–] Moops 6 points 22 hours ago

No no no, it's the fucking that puts the "cow" in "cowboy".

Cowboy in c/lemmyshitpost

Muslims who voted for Trump upset by his pro-Israel cabinet picks in c/leopardsatemyface

[–] Moops 5 points 3 days ago

I hope the decision turns out well for them.

Muslims who voted for Trump upset by his pro-Israel cabinet picks in c/leopardsatemyface

[–] Moops 94 points 5 days ago (50 children)

Right!? I've been so confused by the notion of Trump being the anti-Israel vote. That's not what I heard him say.

The doctor then had to go and treat that lawyer for being a burn victim in c/lemmyshitpost

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

Yeah that makes sense. I used to work in a position where I had to testify in court regularly about the results of independent findings the court requested. There were often lines of questioning that were about establishing details. The questions seemed silly, but it wasn't about the specific pieces of information it was about establishing that "Thing A" was absolutely true (or false) as of a specific point on a timeline. I never had any fun exchanges like this though lol.

Management in c/funny

[–] Moops 6 points 1 week ago

Oh man, I know this is just for funzies, but this hits home. I'm stepping in as an interim next week for a manager who was just removed and I feel like the old manager and team was the victim of this. Fingers crossed I can actually help at this point.

Ahhh more ableist classics in c/chronicillness

[–] Moops 43 points 1 week ago

Ok but, and hear me out, what if my brain's right about the level of danger I'm in?

What's retarded Strength ? in c/[email protected]

congratulations in c/[email protected]

[–] Moops 2 points 1 week ago

I'm speaking to the topic of the post, specifically to the deluge of posts and articles that dissuaded votes from Harris due to the Biden administration's actions/inactions on the Gaza genocide. And while their glibness is noted, my point remains: the chosen alternative is going to be much, much worse. I hope I'm wrong. Time will tell.

And to the broader election. Of course this isn't the only reason she lost, but it's one of them.

congratulations in c/[email protected]

[–] Moops 19 points 2 weeks ago (1 children)

For believing they'll do what they said they would? Sure, I guess. It's telling when insults are your only response.

congratulations in c/[email protected]

[–] Moops 26 points 2 weeks ago (5 children)

Should prolly find a new soap box to write walls of text about. The genocides you allegedly care so much about will now certainly come to an end, likely rather quickly. Buckle up. But hey, at least we showed her right?

Ban to stop children from ever smoking a cigarette to be introduced in Parliament in c/[email protected]

[–] Moops 4 points 2 weeks ago

I hope it works. History seems to suggest criminalizing vices doesn't have a great success rate, but I hope this one takes.

7

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

submitted 3 months ago* (last edited 3 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 1 year ago* (last edited 1 year 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 1 year ago* (last edited 1 year 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.