Dremor
@Dremor@lemmy.world
- Comment on Oracle Layoffs: Tech giant to slash 30,000 jobs as banks pull out from financing AI data centres | Company Business News 1 day ago:
Probably, but I won’t touch that shit unless I have no way doing otherwise.
- Comment on Oracle Layoffs: Tech giant to slash 30,000 jobs as banks pull out from financing AI data centres | Company Business News 2 days ago:
Yeah, you can do pagination, but you need two request : one to select everything, the second to only return the results between id x and id y. Needless to say, the performances are far from ideal.
But in recent version you do skip and take x, which is far easier to write. But my codebase date back to the 2000’s, and it uses the old ways.
As an example, an SQL request to filter on an handful of parameters, and paginate, easily amount to 40-50 lines of SQL. And that’s the easy ones, because some request uses multiple view, in which case I wouldn’t be surprised to find a request doing more than 100 lines of SQL, maybe without even factoring the view in.
- Comment on Oracle Layoffs: Tech giant to slash 30,000 jobs as banks pull out from financing AI data centres | Company Business News 2 days ago:
I work with a client using an Oracle DB. You have to do multiple request to even do something basic as pagination 😂.
They improved it over the years, but given the choice, I’d advice for anything else than Oracle. I’d even prefer MS Sql, which, given I’m pretty anti-MS, is a miracle.
- Comment on Tech industry is in tariff hell, even if refunds are automated 3 days ago:
To rethink something, it would require to think first.
- Comment on Mike Hardaker accuses Reddit of holding organic posting ‘hostage’ unless he buys ads, shares email screenshot 2 weeks ago:
Sound more like you learned the hard way what “abusing the system” mean.
- Comment on Good news, UK Discord users, we're part of a Peter Thiel-linked data collection "experiment" 3 weeks ago:
Your argument cannot be considered as an "reductio ad absurdum”, as it didn’t show any absurdity in your opponent arguments. Your argument could be considered as either an “argumentum ad lapidem” (dismissing a claim as absurd without demonstrating proof for its absurdity), but more realistically it is indeed a strawman, as you try exaggerate you opponent argument in order to weaken it (avoid because Israeli != avoid because of possible link to Israeli intelligence ties).
Still, you are right to doubt some of your opponent proofs. I too have my doubt on that claim, but don’t have the time right now to fact check it.
Feel free to link your own research here, if you find more reliable sources. - Comment on Western Digital Has No More HDD Capacity Left, as CEO Reveals Massive AI Deals; Brace Yourself For Price Surges Ahead! 3 weeks ago:
Idk, I still see 256GB one for 10€ in my local supermarket.
- Comment on Western Digital Has No More HDD Capacity Left, as CEO Reveals Massive AI Deals; Brace Yourself For Price Surges Ahead! 3 weeks ago:
That a shitty analogy… But a good one.
- Comment on E-bikes are just bicycles with a motor. Therefore, e-bikes are motorcycles. 3 weeks ago:
Depends on the juridictions. Some countries make it mandatory pedaling (mine does), other don’t.
- Comment on I Live In Eastern Europe And I'm Making A Creepy Game About Authoritarianism (Demo Is Live) 3 weeks ago:
Wouldn’t say GOAT, but I sure try to do my work the best I can.
- Comment on I Live In Eastern Europe And I'm Making A Creepy Game About Authoritarianism (Demo Is Live) 3 weeks ago:
Hey there Road_Warrior_10, good luck with your new game.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
I did, I use Lawnchair.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
Which is alright. It’s their project after all. I find myself very happy from my Murena Fairphone (except the launcher, which I hate), so I’ll probably be a good Fairphone/Murena client for the years to come.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
That’s fair. We all have our needs, and I find mine in Fairphone + e/OS, which is nice. And when I upgrade, I get to give my parents an almost new, still supported phone, which is nice.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
Low-range, yes. Mid-range, no. As soon as you get de decent quality camera, given you know how to use it, you’ll always get better result than smartphones.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
I’m not that much into photos, so I can’t really judge. In my book, it is OK.
If you want to get good pictures, nothing will ever beat a dedicated camera, even a mid-range one is way better than a smartphone, even an high-end one, due to the size limitations.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
Some of those requirements are really hard to get for non-Google devices. EOM don’t get updates as early as Google engineers gets. It takes time to validate everything, especially since their don’t control their own hardware.
Those requirements are more a way to not appear like dicks by telling that they’ll only supports Pixels.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
With unofficial parts you can get anything, from very good parts to outright dangerous ones (especially batteries).
The problem with IPhone is their association system (which is illegal in the EU BTW). Understandable with those dangerous part on the market, but far too overcharging. They could just warn you during boot or something like that.
As for the software wall, it is where Fairphones shines. Even when the official support ends, the custom ROMs keeps updating for a while. IPhones are great on that aspect too, Samsungs are OK, but can’t say for other brands.
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
The choice of only supporting Pixels comes from GrapheneOS’s side, not Fairphone. Fairphone got some great ROMs support, and even have an official partnership with one of them (e/OS).
- Comment on I want a phone I can actually fix, and Fairphone’s record growth shows the world does too 4 weeks ago:
First party spare parts or third party sketchy spare parts?
Spare part availability comes partly from the popularity of a phone, and iPhones were pretty popular.
Fairphone is just starting to get some steam, so third party spare part may start appearing in the future. same for used parts.Fairphones got a lot better lately. I got both the 4, 5, and now gen 6, and the latest one feels like a good phone, unless the FP4 which is a brick in comparison. Still lacks several Flagship feature (wireless charging, amongs other), but as a mid-range phone it is quite good.
And the repeatability is great. I repaired my FP4 once (usb-c port), and it was easy as heck.
- Comment on Western Digital details 14-platter 3.5-inch HAMR HDD designs with 140 TB and beyond 4 weeks ago:
My Z2 had à drive failure recently, with 4To drives. Took me almost 3 days to re-silver the array 😅. fortunately had a hot spare setup, so it started as soon as it failed, but now a second drive is showing signs of failing soon, so I had to pay the AI tax (168€) to get one asap (arriving Monday), as well as a second one, cheaper (around 120€), but which won’t arrive until the end of April.
- Comment on Mamdani to kill the NYC AI chatbot caught telling businesses to break the law— New York mayor says terminating the ‘unusable’ bot will help close a budget gap 5 weeks ago:
Better than a benchmark, you should try Boinc or Folding@Home.
Heating by science.
- Comment on Mamdani to kill the NYC AI chatbot caught telling businesses to break the law— New York mayor says terminating the ‘unusable’ bot will help close a budget gap 5 weeks ago:
A model being local doesn’t make it magically better than cloud based ones. Especially since your local hardware may not be as optimized as professional hardware.
And I say that as a local AI user.
The way to make it less harmful mainly comes from external factors :
- The origin of the electricity (renewable)
- Shift consumption to a time of low demand (or use a residential battery)
- Use specific hardware for specific tasks (use less energy per token)
- Comment on Steam Owner Valve Faces $900 Million Lawsuit Over PC Monopoly Claims, Following UK Tribunal Ruling - IGN 5 weeks ago:
Well, I agree that US companies do get fined a lot in the old world… The question is, is it because they break the law all the time or because of some sort of conspiracy?
According to Ockham razor, the first should be considered first, then, if disproved, the second can be considered.
- Comment on Steam Owner Valve Faces $900 Million Lawsuit Over PC Monopoly Claims, Following UK Tribunal Ruling - IGN 5 weeks ago:
We could see that 😂
And Republican I suppose ?
If someone from the US break a law in a foreign country, why shouldn’t it be prosecuted ?
- Comment on A mod to use the Ring's power SOM 1 month ago:
That’d be question for !VideoGameSuggestions@lemmy.zip
- Comment on r/Silksong joins lemmy! 1 month ago:
Welcome on this side of the web. I hope you’ll find it cozy, and full of new encounters.
I’ll add your sub to the sidebar asap.
- Comment on Hytale is OUT NOW in early access! 1 month ago:
Depending on how said shit is done, could be better than Minecrft.
- Comment on There aren't any ancient ruins with crazy traps and riddles 1 month ago:
Or check your encoding. Happened to me. 😅
- Comment on There aren't any ancient ruins with crazy traps and riddles 1 month ago:
There is one job that does what archeologist does in films: software engineers.
You have to decipher ancient languages, riddles, and have to avoid traps all the times.
Sure, you don’t go into deep jungle, but you sometimes get to dive into the deep web to find traces of documentations to help resolve a specific case.