Update: The original dev does not remember exactly. However they have said that clientId was originally a VARCHAR, so this may have been checking for both '0' or ''

So an over-engineered workaround to a bad datatype perhaps?

I forgot to mention this is in SQL Server, so SIN operates on radians. So I THINK this can only ever cast to a 0 when clientId is also 0

It certainly doesn’t for any of the 100,000 existing rows

The client table has around 100,000 rows each with a unique clientId, none of which are returned from the CAST / ABS / SIN

I think you are right and this is a ‘fix’ for something lost to time. I am going to talk to the original dev tomorrow to see if they remember what it was for

Thank you so much, I’ll check it out!

Absolutely, it’s a great read. Could you link the video you watched?

1. Soft Skills Engineering - Software engineering advice podcast
2. If Books Could Kill - Criticising reviews of bestselling books
3. CoRecursive - Stories about software

Not specific to AI, some of the people I work with make me prone to drinking as well

These are really nice! Thank you

I followed Paged Out for a year before I realised that Issue #3 was never going to happen

So far really good! It has some quirks, and there are some bugs and some teething issue with the large influx of people (specifically on lemmy.ml)

It is a mind-set change working with a different system and the whole instance idea is still very new for me

As an Australian, it was very quiet last night (10ish hours ago), but that will improve as more people join

What about if I want to link to a post that will work for the local instance?

For example, @huojtkeg@lemmy.world posted above that https://lemmy.world/post/58535 is his instance link, and https://lemmy.ml/post/1205894 is the link from lemmy.ml. Neither of which allow me to comment directly.

Is there linking method that says Give me the link for post #X on instance Y, but give me the link on the viewing instance?

so if the operator of rambo goes “man fuck this” and shuts it down, the posts/comments are gone? there’s no way to replicate them or sync them or whatever?

My understanding is that if a user on a different instance is subscribed, then that second instance will keep copies of previous post / comments.

But there also appears to be a download limit, so over time the non-original instances will lose those copies.

It’s a strange new world over here!

Oh yes, you are right! Specifically All doesn’t work.

I have found a bug report listed for it, and it should be fixed in the next release - 0.18.

I want to say it is an issue with your instance, but we actually run the same UI and BE version.

Maybe something to do with the server issue lemmy.ml is experiencing.

Same thing if you log out and back in?

I have saved mine in my profile and they are working correctly.

When you load the profile after the save, have they reverted there? Or is it that when you view your home page the ordering is incorrect?

Yeah, very concerning!

I think it is related to this change, so maybe the sanitize is causing the issue here.

I am not the author, but I found this an amazing write-up