sql
SQL 4mo ago
Jump
Guess the intent
  • Threen Threen 4mo ago 100%

    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?

    1
  • sql
    SQL 4mo ago
    Jump
    Guess the intent
  • Threen Threen 4mo ago 100%

    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

    3
  • sql
    SQL 4mo ago
    Jump
    Guess the intent
  • Threen Threen 4mo ago 100%

    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

    4
  • sql
    SQL Threen 4mo ago 100%
    Guess the intent

    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`

    23
    9
    Hacking Millions of Modems (and Investigating Who Hacked My Modem)
  • Threen Threen 4mo ago 100%

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

    4
  • Hacking Millions of Modems (and Investigating Who Hacked My Modem)
  • Threen Threen 4mo ago 100%

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

    4
  • https://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

    59
    4
    What are your top three favourite podcasts?
  • Threen Threen 9mo ago 100%
    1. Soft Skills Engineering - Software engineering advice podcast
    2. If Books Could Kill - Criticising reviews of bestselling books
    3. CoRecursive - Stories about software
    3
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
    pokemongo Threen 1y ago 0%
    Great Storage Box past 6800?

    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
    0
    "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
    pokemongo 1y ago
    Jump
    Share Trainer Codes
  • Threen Threen 1y ago 100%

    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

    3
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
    pokemongo Threen 1y ago 76%
    Glitched avatar

    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

    7
    0
    "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
    pokemongo 1y ago
    Jump
    Routes?
  • Threen Threen 1y ago 100%

    This is in my nearby list

    This is in my profile

    1
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
    pokemongo Threen 1y ago 100%
    Routes?

    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?

    11
    5

    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?

    2
    0
    Subscribing to a community from another instance always shows "Subscribe Pending". Is this a bug?
  • Threen Threen 1y ago 100%

    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

    2
  • I somehow broke my ssh keys
  • Threen Threen 1y ago 100%

    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?

    1
  • Eclipse compiler issue
  • Threen Threen 1y ago 100%

    Yeah mate, you are right "doesn't work" is pretty useless, lucky I didn't say that

    I said I have code that does compile in one specific compiler but doesn't in another specific one, and asked if anyone had ever encountered that before

    And 2 days ago when someone mentioned that I didn't include the actual error, I apologised and then included it

    1
  • Is it just me or...?
  • Threen Threen 1y ago 100%

    On the website, or on an app?

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

    1
  • Programming Music
  • Threen Threen 1y ago 100%

    Maybe something like "Drone Techno"?

    https://youtu.be/8meK_YYLcrA

    4
  • Programming Music
  • Threen Threen 1y ago 100%

    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

    1
  • 2039 - Tom Mauritzon
  • Threen Threen 1y ago 100%

    @orbit@beehaw.org just suggested this 24-hour cyberpunk playlist to me too

    1
  • Programming Music
  • Threen Threen 1y ago 100%

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

    2
  • Programming Music
  • Threen Threen 1y ago 100%

    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)

    2
  • 2039 - Tom Mauritzon
  • Threen Threen 1y ago 100%

    Glad you like it, I will definitely check out Citizen Sleeper!

    Raiding my memory banks, I remember the Frozen Synapse OST to be amazing too

    1
  • Programming Music
  • Threen Threen 1y ago 100%

    Wow there is a lot there! Thank you

    I will listen to a few at work this week

    2
  • https://somafm.com/dronezone/

    I am a big fan of listening to Drone Zone on SomeFM while programming Hit me with your favourite streams, albums or artists

    31
    40
    https://youtu.be/_QMyUMPH2HE

    I fell in love with this album many years ago, I hope someone here will enjoy it too

    7
    3
    "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
    pokemongo Threen 1y ago 100%
    Anyone need a River Vivillon region gift?

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

    3
    0
    github.com

    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.

    5
    1

    I am wondering if anyone can help me. I have an issue with compiling some code in Eclipse but not with IntelliJ or javac. I am using [sneakyThrow](https://www.baeldung.com/java-sneaky-throws#sneaky) to bubble a checked exception up through 2 streams. Here is the smallest reproducible code I can make: ``` import java.io.IOException; import java.util.List; import java.util.function.Predicate; import java.util.stream.Collectors; public class Example { public static void main(String[] args) throws IOException { List<List<Integer>> input = List.of(List.of(1, 2), List.of(2, 4)); // Should return any List whose elements are all even. List<List<Integer>> output = input.stream() .filter(bubblePredicate(o -> o.stream() .allMatch(bubblePredicate(i -> { if (i > 10) { throw new IOException("Number too large."); } return i % 2 == 0; })))) .collect(Collectors.toList()); System.out.println(output); } private interface ThrowingPredicate<S, E extends Exception> { boolean test(S s) throws E; } private static <S, E extends Exception> Predicate<S> bubblePredicate(ThrowingPredicate<S, E> callable) throws E { return s -> { try { return callable.test(s); } catch (Exception e) { sneakyThrow(e); return false; } }; } private static <E extends Throwable> void sneakyThrow(Exception exception) throws E { throw (E)exception; } } ``` Compiles and runs completely fine with `javac 11.0.12`, but doesn't on `Eclipse 4.21.0.I20210906-0500` nor `Eclipse 4.27.0.20230309-1200`. Has anyone encountered this before, or have any idea what I am misunderstanding?

    1
    6

    Can probably only send you 1 gift, as my friend list is quite full 0692 0102 3964

    2
    0