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.

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.

My ISP doesn’t support IPv6, now what?

It’s really bullshit.

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.

News flash: Even if they do that, your body is already full of microplastics as it’s in your food. So not sure if this is going to help even one bit :)

You already didn’t.

Let’s be real here, they weren’t shut down for being an emulator, they were shut down for charging money and making bank, while also planning a parallel paid online service. All the other emulator projects are trucking along just fine, even if Nintendo hates some of them for decades by now.

Mobile is an entirely different beast. Like sometimes my keyboard doesn’t show up. Or the text select refuses to work. And so on. It’s a mess. Even on a Galaxy S22.

No clue how people can exist without a proper computer at home and still do stuff online.

Ctrl + C literally doesn’t work at times, it drives me crazy. It might be due to some shitty applications and websites overriding it or adding complexity (Like copying not only the text but additional information).

I’m often 100% sure I copied the text, change the window and an old clipboard entry gets pasted.

There’s no Visual Studio for Linux, so yeah… especially as a .NET dev.

Visual Studio Code isn’t the same.

Articles usually have images and possibly embedded videos. So it’s not just text.

Even so, a decent webserver wouldn’t really care.

Maybe it loads faster for mobile users though if you only load text and a single image at first.

Yeah, I’ve worked with the leave it alone types. What do you get in return? Components of your system which haven’t been updated in the last 20 years and still run .NET 3.5. They obviously never stopped working, but you have security concerns, worse performance (didn’t matter much in that case) and when you actually need to touch them you’re fucked.

Why? Because updating takes a lot of time (as things break with every major revision) and on top of that if you then decide not to update (yeah, same coworker…) then you have to code around age old standards and run into bugs that you can’t even find on Stack Overflow, because people didn’t have to solve those in the last 20 years.

Rare North Korea W

This isn’t an actual step forward, just a ploy to keep religion going for as long as possible.

It’s obviously all a lie, they just keep softening their policies to stay relevant in modern times. Imagine if they stuck to their old believes from a few hundred years ago or actually followed the bible, they’d become irrelevant in just one generation.

So instead they adapt to keep their power.

deleted by creator

Yes, but I was talking about the salary part, which is separate from the costs you mentioned.

It’s 19 million just for people.

Is it just me or is $19 million per year for 50 full-time employees insane?

Even for US salary standards.

If it’s an existing language then it’s not secure.

If you make up your own language you’ll waste a thousand hours and someone might use the notes you used to learn it.

Just use damn encryption, it’s easy and fast. Also has additional benefits. If someone wants to force you to give them/translate your notes you can’t do much (they’ll know when your translation is inconsistent).

With encryption you can hide a volume inside another one. If you enter the weaker password you can put decoy files there, with just your run of the mill notes. While behind a stronger password you hide your actual diary.

That’s stupid, any cypher you can keep in your head is easily cracked.

If you want privacy, look towards encryption. Get a cheap laptop without internet access, install whatever Linux distribution, then keep everything encrypted.

So all you need to keep in your head is your master password.