overview for Moops

An open letter to U.S. customers in c/[email protected]

[–] [email protected] 2 points 2 months ago

I appreciate the conversation. We have different beliefs but you make solid arguments I enjoyed reading.

An open letter to U.S. customers in c/[email protected]

French Tesla Dealership Torched By Anarchist Group in Proclaimed 'Offensive Against Techno-Fascists' in c/[email protected]

[–] [email protected] 13 points 2 months ago

These articles give me joy.

Should I do revenge on my neighbour in c/[email protected]

[–] [email protected] 10 points 3 months ago (1 children)

NO HE SAID HE WANTS HIS PAIR OF UGGS

Is there nothing sacred in this forsaken world anymore? in c/[email protected]

[–] [email protected] 42 points 4 months ago* (last edited 4 months 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/[email protected]

[–] [email protected] 18 points 4 months 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]

[–] [email protected] 1 points 5 months ago* (last edited 5 months 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]

[–] [email protected] 21 points 5 months 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/[email protected]

[–] [email protected] 3 points 5 months 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!

7

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

submitted 10 months ago* (last edited 10 months ago) by [email protected] to c/[email protected]

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.

1

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

submitted 2 years ago* (last edited 2 years ago) by [email protected] to c/[email protected]

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.