Damn, they are getting younger and younger. Just recently a 13 year old drilled into a patient during brain surgery in Austria /s

Good joke, you’d have to double and triple check every single citation as LLMs love to hallucinate.

I wouldn’t risk my title or expulsion because an LLM fucked up my work. Even one missed reference or a false citation could cost you plenty.

Steam simply due to the convenience and already having a ton of games there. Steam sales are nice too of course.

GOG is awesome, but more for older games or for games I want to play at a LAN. Like the good old days where you hang out with friends, throw a CD (or now USB stick) their way and ten minutes later you’re playing together.

The secret is a bidet. Much cleaner and suddenly I spend a third on toilet paper compared to before (you still use some for drying and checking).

designing a vote weighting system that favors similar instances

Would make the whole thing even worse, as I could create several new instances with 10 bot users each, then hammer out the votes.

The entire problem is that you can’t trace back each vote to a genuine user. It would be bad in case of fake instances that create 100 user accounts and upvote/downvote stuff, but you can ban the instance. It would be a disaster if a big instance creates fake votes (like lemmy.world suddenly adds 1000 fake users and uses them to manipulate other instances, if votes were anonymous you couldn’t check if it’s genuine lemmy.world users or fake accounts).

It would be damn easy to look up the instance and their “users” and see that the users are not genuine. Then ban the whole instance.

The problem isn’t keeping votes anonymous, that’s easy. The problem is bots/spam. You could just create a new instance and then upvote a post from another instance a thousand times. If the votes are anonymous for the other instance it’s tough to say if they are genuine users or just bots.

That’s the main issue here, when votes are anonymous you could easily just spam votes with no way to trace it back. If it’s a rogue instance then fine, you can ban the whole instance. But imagine if lemmy.world starts using fake votes in the background towards other instances.

I really don’t see the issue there, you’re only outputting highly specific data to a website, not dumping half the database.

Do you mean your typical CRUD structure? Like having a User object (AuthId, email, name, phone, …), the user has a Location (Country, zip, street, house number, …), possibly Roles or Permissions, related data and so on?

SQL handles those like a breeze and doesn’t care at all about having to resolve the User object to half a dozen other tables (it’s just a 1…1 relation, on 1…n, but with a foreign key on the user id it’s all indexed anyway). You also don’t just grab all this data, join it and throw it to the website (or rather the enduser API), you map the data to objects again (JSON in the end).

What does it matter there if you fetched the data from a NoSQL document or from a relational database?

The only thing SQL is not good at is if you have constantly changing fields. Then JSON in SQL or NoSQL makes more sense as you work with documents. For example if you offer the option to create user forms and save form entries. The rigid structure of SQL wouldn’t work for a dynamic use-case like that.

I mean in my case it’s for an international company where customers use this structure and the depth can basically be limitless. So trying to find the topmost parent of a child or getting all children and their children anywhere inside this structure becomes a performance bottleneck.

If you have a single level I really don’t understand the problem. SQL joins aren’t slow at all (as long as you don’t do anything stupid, or you start joining a table with a billion entries with another table with a billion entries without filtering it down to a smaller data subset).

If you only join on indexed columns and filter it down to a reasonable number of results it’s easily fast enough.

For true hierarchical structures there’s tricks. Like using an extra Path table, which consists of AncestorId, DescendentId and NumLevel.

If you have this structure:

A -> B -> C

Then you have:

A, A, 0

A, B, 1

A, C, 2

B, B, 0

B, C, 1

C, C, 0

That way you can easily find out all children below a node without any joins in simple queries.

Well, there’s modern C++ and it looks reasonable, so you start to think: This isn’t so bad, I can work with that.

Then you join a company and you find out: They do have modern C++ code, but also half a million lines of older code that’s not in the same style. So there’s 5 different ways to do things and just getting a simple string suddenly has you casting classes and calling functions you have no clue about. And there’s a ton of different ways to shoot your foot off without warning.

After going to C# I haven’t looked back.

I still remember 10 years ago when I was driving on the Autobahn at 130 km/h and a juicy bug hit the windshield. It was literally a loud splat. Besides the grill always being covered in bugs.

Hasn’t happened since, nowadays I can count the number of bugs on the grill with one hand. And that’s after months of driving.

I already can’t hit the song selection forward/backward button consistently while the wheel is turned. Especially in a roundabout where I always indicate on exit. I don’t have to try it, steering wheel buttons for driving functions fucking suck.

Besides not wanting to buy a product from Musk buying a Tesla simply isn’t an option.

On the newest Model 3 they removed the stalks, I don’t want to press a button on a steering wheel to use the blinker (Doing that in a roundabout sounds like a nightmare).

Besides that Musk seems to think he can do whatever he wants with OTA updates. I wouldn’t want to buy a car that might have some function changed or disabled the next time I’m using it.

Plenty of other manufacturers at this point to choose from.

No, it’s not. Most people, even in the US, can easily use the range. You don’t go to a cross country roadtrip every day.

You drive to work, go grocery shopping, drive home and that’s usually it. A range of 400km+ with new EVs is easily enough. Or do you drive to the gas station every 2 days with your current car?

And even if you go on a roadtrip, after driving for 4 hours you might want to take a break anyway.

You do realize there is no data available for the future? We aren’t there yet.

You do realize most people charge at home? It doesn’t matter how long it takes when the car is just sitting there (you’ll even save time compared to driving to the gas station).

Manufacturers also give 7+ years warranty on batteries by now, but even after 10 years a battery doesn’t just break, you only lose a few percent of range (if this wasn’t already calculated into the buffer, depends on the car).

You do know EV sales stall because of that, right?

In what fantasy world are you living? EVs just hit an all-times sales record last year. This is for the US, but it’s similar all over the world:

Right now I could buy an EV with 520km range for 36k€. It’s rapidly getting better.

Are we? There’s still plenty of space for solar and wind. Including large battery installations for cities. It doesn’t really feel like we’re hitting a limit there anytime soon.

The Skat Injector song in the article sounded like annoying noise. But I could actually vibe a little bit to the song by Gridbug.

But mostly it just sounds like noise and not actual music to me (Like my ears don’t even seem to interpret it as music). Still interesting!

More? It feels like nine out of ten war movies focus on WW2. You can’t throw a stone at IMDB without hitting three WW2 movies and a series along the way.