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.

I mean I didn’t check how long it actually takes, it’s not 500ms.

It opens quick, but I can’t find the default value (you can change the behavior via registry), but it’s definitely less than half a second. Especially when you’re already hovering down there it appears near instant for me.

And let’s be honest: The only reason why multiple icons worked back in the day was because the name of the open workbook was next to it. So you had “(Excel) My Workbook 123.xlsx” in your taskbar. Which ended up as a mess when you had several programs open. Now you have one Excel icon, you hover over it and you see all your open workbooks as a preview so you select the one you want. It’s definitely cleaner.

Well, you can’t directly click, but all you need to do is hover for half a second, then click the window you want (which open up above). It’s a non-issue.

Of course, but it’s mostly for reading. The color will probably be used for notes and the occasional image, for which it’s easily good enough. When I read it’s usually a foot away, while I keep my monitor at 2 feet.

Black and white content (text) has 300 dpi atleast, so for that it’s perfect.

E-Ink is fantastic for lots of reading and battery life, for everything else an actual screen is leagues ahead. The response time is awful too.

Both use E Ink’s latest Kaleido color screen technology, which has subtle, pastel-like hues and drops from a 300ppi grayscale resolution to 150ppi when you view content in color.

I had to check just how bad 150ppi would be when dropping down the resolution for color.

A 24" Full HD monitor has a PPI of 92. So it’s actually okay.

I’m still using my old Kobo Aura HD (now roughly 11 years old) and the battery still lasts over a month. The screen was already decent back then, but a bit sluggish. I just checked, the old one has 265 ppi. Maybe it’s not time for an upgrade yet :)

I mean for working out and on the go I use Bluetooth ear buds.

But damn do I sometimes wish I still had a headphone jack on my phone. Like just grabbing my nice pair of open ear headphones, throwing down on the couch and listening to music for example.

And of course I always had backup wired ear buds with me, just in case the battery ran out.

But eh, I can live without the headphone jack, now I just wish they would have used the space for a bigger battery.

That’s not the reason, you have been able to do so for a while. Even longer if you count Breath of the Wild (which ran with the Wii U emulator). The only reason they got their shit kicked in by Nintendo is greed. Patreon + extra money for early access + wanting to create their own paid copy of Nintendo’s online service + timing their press releases with Nintendo releases…

Emulators are legal. Fully intending to profit from creating a competing product isn’t. That’s why they also gave in so quickly when the lawyers showed up, despite having plenty of money to afford defense.

Be sure to unplug the windows drive before installing Mint to the other drive.

Why would you do that? Totally unnecessary. When Windows is already installed any Linux installation respects it without issues. The problem is the other way around, if you install Linux first and then install Windows afterwards on a second partition/drive it nukes your Linux bootloader.

Especially in times of M.2 drives (which are often behind the GPU) you only annoy people by telling them to unplug their Windows drive first. And they might want to use a second partition on that drive if it’s bigger.

I was rather happy with Netflix for nearly a decade. The price was reasonable and family members could also watch. When I moved out I upgraded to the 4K package (split 3 ways between family members) and it was fine at first.

But there were several caveats:

• 4K only works on TVs, on my 1440p monitor I could only watch 1080p. Sucked, but it’s not too bad
• Price kept going up, in the end it was 18€ a month. That’s okay split between 3 people, but otherwise far too much for what is offered
• Series that I liked kept getting cancelled, while trash was getting renewed or they messed up the later seasons (Looking at you, The Witcher…)
• They cracked down on password sharing, suddenly you need to be in the same WiFi to count as home or you need a travel code (limited to 2 a month and only for 2 weeks each), so if you regularly move between places it’s a no-go for a service you pay for

I finally cancelled it, sick of their shit. Which also has the benefit of no longer having to take care of the account for the family. Unfortunately my dad accidentally took over the account (while trying to create a new one) and keeps paying the 4K price (I suggested at least going down to 1080p as the quality is shit either way). Simply idiotic :-/

Personally I tried out Real Debrid and it has been pretty alright so far. The quality is better too, which is ridiculous.

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.

This isn’t about dev salaries at all. It’s about cheap investment money, you got huge amounts of funds with a very low interest rate.

Now the interest rates are up, money lending is no longer cheap. Suddenly all those companies actually need a profit to run, which they don’t have.

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.

deleted by creator

Most of the entries were just funny, the last one is a nuke:

70. I heard that the only real application for that technology was child pornography. How did you hear about it?