Threen

joined 2 years ago
sorted by: new top controversial old
Guess the intent in c/[email protected]
[–] [email protected] 2 points 10 months ago

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?

Guess the intent in c/[email protected]
[–] [email protected] 3 points 10 months ago

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

Guess the intent in c/[email protected]
[–] [email protected] 4 points 10 months ago (2 children)

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

23
Guess the intent (aussie.zone)
submitted 10 months ago* (last edited 10 months ago) by [email protected] to c/[email protected]
8 comments fedilink
 

I am one of the developers on a very small team and have just found the following query

I would love to hear your ideas for what you think was being attempted here!

SELECT ... FROM client WHERE CAST(ABS(SIN(clientId)) AS BIT) = 0

Hacking Millions of Modems (and Investigating Who Hacked My Modem) in c/[email protected]
[–] [email protected] 4 points 10 months ago

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

Hacking Millions of Modems (and Investigating Who Hacked My Modem) in c/[email protected]
[–] [email protected] 4 points 10 months ago (2 children)

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

61
Paged Out! is a free experimental technical magazine (pagedout.institute)
 

I hope some people here enjoy reading these as much as I have

If you know of anything similar, I would love to hear them

34
Hacking Millions of Modems (and Investigating Who Hacked My Modem) (samcurry.net)
What are your top three favourite podcasts? in c/[email protected]
[–] [email protected] 3 points 1 year ago* (last edited 1 year ago) (1 children)
  1. Soft Skills Engineering - Software engineering advice podcast
  2. If Books Could Kill - Criticising reviews of bestselling books
  3. CoRecursive - Stories about software
2
Great Storage Box past 6800? (aussie.zone)
 

I have the maxed out Pokemon storage of 6,800. Does anyone know if I buy the Great Storage Box if it will still increase this?

2
Glitched avatar (aussie.zone)
submitted 2 years ago* (last edited 2 years ago) by [email protected] to c/[email protected]
0 comments fedilink
 

Found an interesting little glitch

  1. Close your game
  2. Turn your phone's GPS off
  3. Start the game and as soon as it loads open routes
  4. Turn GPS back on and after a few seconds close routes

Gyms and stops don't appear

Pokemon cannot be clicked on

1
Routes? (aussie.zone)
 

What am I meant to be doing with "routes". There are none around me to follow and I cannot seem to create a new one

I am missing something? Do I need to complete something?

1
Testing instance and wiping data (aussie.zone)
 

I am wanting to test things and contribute back to lemmy's codebase, and to do that I want to run an instance

I have had no issue setting up an instance, but I want to make sure the things I test / change are not going to cause issues for the fediverse

For example, if I federate a remote instance and then wipe my DB (while keeping the same URL), will that other instance be able to handle the change?

Is there a best practice for this that I should follow?

Testing a new encrypted messaging app's extraordinary claims in c/[email protected]
[–] [email protected] 1 points 2 years ago* (last edited 2 years ago)
13
Programming Music (somafm.com)
 

I am a big fan of listening to Drone Zone on SomeFM while programming

Hit me with your favourite streams, albums or artists

Testing a new encrypted messaging app's extraordinary claims in c/[email protected]
[–] [email protected] 1 points 2 years ago (1 children)

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!

Working with AI tools is making employees lonely and prone to drinking, a study finds in c/[email protected]
[–] [email protected] 16 points 2 years ago

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

1
Anyone need a River Vivillon region gift? (aussie.zone)
 

I work on top of pokestops, so add me and you'll get one today

0692 0102 3964

Redditors, how do you like Lemmy? in c/[email protected]
[–] [email protected] 3 points 2 years ago* (last edited 2 years ago)

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

5
Testing a new encrypted messaging app's extraordinary claims (crnkovic.dev)
Testing a new encrypted messaging app's extraordinary claims in c/[email protected]
[–] [email protected] 1 points 2 years ago

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

1
Testing a new encrypted messaging app's extraordinary claims (crnkovic.dev)
view more: next ›