Moops

joined 1 year ago
[–] Moops@lemmy.world 41 points 4 days ago

Political violence is pretty party-specific.

[–] Moops@lemmy.world 18 points 1 week ago* (last edited 1 week ago)

There was a post on that other site a few years back where someone found a locked safe and posted about it. I wanna say they were asking for advice about how to open it (I'm fuzzy there), but it turned into this whole thing where it felt the whole internet was hanging on a cliff edge, waiting to see what was in it. People were guessing, making bets, giving advice, promising first born etc.

Nothing. There was nothing in it. It was empty the whole time. A little piece of me died that day.

[–] Moops@lemmy.world 30 points 1 week ago (2 children)
[–] Moops@lemmy.world 34 points 1 week ago (7 children)

Bruh. I had almost managed to forget.

[–] Moops@lemmy.world 1 points 1 week ago
[–] Moops@lemmy.world -1 points 1 week ago (4 children)
[–] Moops@lemmy.world 5 points 1 week ago* (last edited 1 week ago)

Oh that's actually interesting. You couldn't on the basis of the mother dying, because her life doesn't matter to conservative leaders and their laws. However, the fetus died as a direct result of the laws they passed. Those very same laws require consequences for anyone responsible for a fetus "dieing". That'd be an interesting case to watch unfold.

[–] Moops@lemmy.world -4 points 1 week ago (6 children)

That's literally the definition of biggotry.

[–] Moops@lemmy.world 15 points 1 week ago (2 children)

As a potato I don't find any of this funny at all.

[–] Moops@lemmy.world 10 points 1 week ago

So pro life.

 

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.

view more: next ›