overview for anonymouse

[–] anonymouse@sh.itjust.works 11 points 4 weeks ago

Tiny Darkhounds?

Alternative open source frontend for Instagram? in c/opensource@lemmy.ml

[–] anonymouse@sh.itjust.works 24 points 1 month ago (1 children)

I saved and older post where this was mentioned: https://imginn.com/ Seems like it's still working and comments are available

To the center of the earth!📉 in c/lemmyshitpost@lemmy.world

[–] anonymouse@sh.itjust.works 1 points 4 months ago

Nice one, forgot this was an option too. You are missing a set of brackets though ;)

Netherlands at 43% participation for "Tax The Rich" petition in c/thenetherlands

[–] anonymouse@sh.itjust.works 4 points 6 months ago (1 children)

Had The same issue yesterday, was probably related to all the digital issues in NL yesterday. I tried again and its working now, just thought to let you know!

12

Humble Books Bundle: Patrick Rothfuss' The Kingkiller Chronicle by DAW Books (www.humblebundle.com)

submitted 6 months ago by anonymouse@sh.itjust.works to c/fantasy@lemmy.ml

6 comments fedilink

Good deal and great series. Just bought and redeemed it using Kobo, very smooth experience.

Olympic Games 2024 Closure Ceremony in c/olympics@sh.itjust.works

[–] anonymouse@sh.itjust.works 1 points 6 months ago (1 children)

I think he was an alien

What are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... ) in c/sql@lemmy.world

[–] anonymouse@sh.itjust.works 2 points 7 months ago* (last edited 7 months ago) (1 children)

First of all thanks for this list, I didn't know about the KEEP functionality so read up on it a bit, I found the following interesting read: https://rwijk.blogspot.com/2012/09/keep-clause.html?m=1

I can't really play around with it at the moment as it seems Oracle only (I think) and I'm not using that at the moment. Might also explain preference for last/first value of your colleague cause it seems more general available.

Question from my side, why is DENSE_RANK used in this case? Seems to me like RANK or ROW_NUMBER could perform better, since there is less to keep track off? Of course ROW_NUMBER could give different results if there are duplicates in the ORDER BY column, but in that case the MAX is also sort of an arbitrary choice.