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

0589 6066 6425

I would love to give gifts to anyone here

I am from Australia, and I travel between Queensland and South Australia regularly

This is in my nearby list

This is in my profile

I think it is a bug and here’s why

I have setup a lemmy instance to understand how it works and hopefully contribute something meaningful

My instance has 2 users, both are subscribed to the same cross-instance community, but only one is showing Subscribe Pending even if I un-sub and re-sub

I am not aware of any approval system to subscribe to a community, so I believe the approval was received the community instance, but the “accept” response data was missed / dropped when returning to your host instance

On the website, or on an app?

I have posted half a dozen things from the Jerboa app and not encountered this

Maybe something like “Drone Techno”?

https://youtu.be/8meK_YYLcrA

Oh yeah, I remember listening to that when they only had around 5 episodes

They still do the high-pitched beep when you start or stop I see haha

Thank you

Over 24 hours of Cyberpunk music?!?! Oh my god Thank You!!!

Thank you, I will check them out!

Two of my old favourites were the Frozen Synapse OST and Dune: Spice Opera (although not technically a soundtrack)

Wow there is a lot there! Thank you

I will listen to a few at work this week

In the timeline at the bottom it says:

2023-05-05: Converso asks: ‘How were you able to decompile the source code of the app and what do you think should be done to protect against that in the future?’

So I think some of the devs were in way over their heads too!

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 Australia, 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?