Threen 3 months 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?
Threen 3 months 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
Threen 3 months 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
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 3 months ago • 100%
Thank you so much, I'll check it out!
Threen 3 months ago • 100%
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 8 months ago • 100%
- Soft Skills Engineering - Software engineering advice podcast
- If Books Could Kill - Criticising reviews of bestselling books
- 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 1 year 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
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?
Threen 1 year ago • 100%
No worries at all
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 1 year 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
Threen 1 year ago • 100%
Let me make sure I understand first
- You are attempting to passwordlessly SSH from Window to a group of servers using Powershell
- 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 1 year ago • 100%
Threen 1 year ago • 100%
Haha, sorry I came across the way I did. I really was racking my brain trying to think what more I could provide. Normally for Java issues I can give a stacktrace, but in this case there is literally only a 4-word error message
When I view the post on your server it shows only our convo, so definitely a federation issue
Threen 1 year ago • 100%
Ohhh, that explains so much!
Threen 1 year ago • 100%
I am really struggling to understand what you are asking me to provide
Java is a compiled language. Eclipse is attempting that compile step and it fails. I have provided the error it gives me, a minimal code snippet to reproduce this, the location that Eclipse indicate the error occurs, and the specific 2 specific versions of Eclipse I have tried
Is it a screenshot of the error you are after? Maybe there is something obvious I am overlooking, but I really do no know what more I can give you
Threen 1 year 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
Threen 1 year ago • 100%
On the website, or on an app?
I have posted half a dozen things from the Jerboa app and not encountered this
Threen 1 year ago • 100%
Maybe something like "Drone Techno"?
Threen 1 year ago • 100%
Over 24 hours of Cyberpunk music?!?! Oh my god Thank You!!!
Threen 1 year 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)
Threen 1 year 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
Threen 1 year ago • 100%
Wow there is a lot there! Thank you
I will listen to a few at work this week
I am a big fan of listening to Drone Zone on SomeFM while programming Hit me with your favourite streams, albums or artists
Threen 1 year ago • 100%
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!
I fell in love with this album many years ago, I hope someone here will enjoy it too
Threen 1 year ago • 100%
Not specific to AI, some of the people I work with make me prone to drinking as well
I work on top of pokestops, so add me and you'll get one today 0692 0102 3964
Threen 1 year ago • 100%
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
Threen 1 year ago • 100%
Oh yes, sorry
The error it gives is that the inner bubblePredicate
has an Unhandled exception type IOException
.
Threen 1 year ago • 100%
And this leads to another question, how can I browses communities on other instances with my already existing account? What about platforms such as mastodon where I'm supposed to be able to browse and submit and such?
I would recommend this
I have also found some interesting communities on !newcommunities@lemmy.world
Threen 1 year ago • 0%
I would love to get suggestions for Japanese resources / apps
I have done a month of Duolingo and I am sick of hearing Ken ask for sushi every lesson!
Threen 1 year ago • 0%
My vote would go towards the Rundle Mall Balls
Threen 1 year ago • 100%
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
?
Threen 1 year ago • 100%
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!
Threen 1 year ago • 100%
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.
Threen 1 year ago • 100%
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?
Threen 1 year ago • 100%
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?
Threen 1 year ago • 100%
Yeah, very concerning!
I think it is related to this change, so maybe the sanitize is causing the issue here.
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.
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?
Threen 1 year ago • 100%
One thing I used ChatGPT for recently was generating test data.
Hey ChatGPT, I use SQL Server and here is my table structure, please generate an insert query with 10 rows of fake test data.
It wasn't perfect, but honestly nor is the test data I would have written. It was a great starting point and saved me a lot of time since this is a legacy app with some wide tables (30+ columns).
Can probably only send you 1 gift, as my friend list is quite full 0692 0102 3964
Threen 1 year ago • 100%
I just installed the "Jerboa" app, and it seems very responsive and easy to use so far
Threen 1 year ago • 100%
I am not the author, but I found this an amazing write-up