Threen

joined 1 year ago
[–] Threen@aussie.zone 1 points 2 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?

[–] Threen@aussie.zone 3 points 2 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

[–] Threen@aussie.zone 4 points 2 months ago (1 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 2 months ago* (last edited 2 months ago) by Threen@aussie.zone to c/sql@programming.dev
 

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

[–] Threen@aussie.zone 4 points 3 months ago

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

[–] Threen@aussie.zone 4 points 3 months ago (2 children)

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

 

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

[–] Threen@aussie.zone 3 points 8 months ago* (last edited 8 months 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
 

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?

[–] Threen@aussie.zone 1 points 1 year ago* (last edited 1 year ago)

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

1
Glitched avatar (aussie.zone)
submitted 1 year ago* (last edited 1 year ago) by Threen@aussie.zone to c/pokemongo@lemmy.world
 

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

 

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?

 

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?

[–] Threen@aussie.zone 2 points 1 year ago

Let me make sure I understand first

  1. You are attempting to passwordlessly SSH from Window to a group of servers using Powershell
  2. Something stopped working and you regenerated your Windows SSH keys

i added my private key, and tried to connect

This concerns me, as the server should have the user's public key, not private. Private should be exactly that, private

Is the Powershell user / SSH key the same as the Putty user / SSH key that still works?

When you run the Powershell script, does it give any error messages?

I know with Linux -> Linux SSH you can log verbosely with -v, is that something you can do under Powershell?

Is password auth enabled? Does that still work from Putty, and can you do the same from Powershell?

[–] Threen@aussie.zone 1 points 1 year ago* (last edited 1 year ago)
[–] Threen@aussie.zone 2 points 1 year ago

On the website, or on an app?

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

[–] Threen@aussie.zone 4 points 1 year ago (1 children)

Maybe something like "Drone Techno"?

https://youtu.be/8meK_YYLcrA

[–] Threen@aussie.zone 1 points 1 year ago

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

 

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

Hit me with your favourite streams, albums or artists

 

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

0692 0102 3964

 

If a post body contains an unclosed HTML tag, it will be automatically closed it at the end of window.isoData and then all Javascript functionality disappears.

view more: next ›