Iirc,mass effect lets you buy anything you miss in a store later, at least

Except the email in question is not a newsletter. Companies often use separate mail list services for important product announcements and similar things as well. Obviously there should be a process in place that removes you from these external services too when you delete your account, but I assume this is what broke down in this case

You’re thinking of Edge, not Internet explorer

!Stars don’t go from yellow to supernova in 22 minutes!<

!I mean, the rules of physics and biology are in general being bent quite a bit by the game. Even just the existence of the Hearthians, a species that developed on a planet that’s tiny and harbors, what, like 30 individuals total? That just falls under stuff that doesn’t make sense in the real world, but I’m willing to accept in order to enjoy the game 🤷!<

Haven’t played the DLC either yet, not sure if that adds anything, but:

[Spoilers for mid-game]

!While you play, you’ll encounter clues that point towards the sun station being the reason for the sun dying, as it was built to make the sun go supernova and use the resulting energy to find the eye of the universe.!<

[Spoilers for late- to endgame]

!Later on, it turns out that the sun station is actually not the reason, as it just didn’t work as the Nomai planned. The sun is actually going supernova because the universe is dying as a whole, as you can actually see all around you, with loads of supernovae going off in the sky. Now sadly, there’s no explanation given for why that is happening much earlier than everyone expected, iirc. I guess that’s a final mystery that’s indeed left unanswered.!<

!the sun changing color and getting bigger, without explaining anything!<

Well, a big part of the game is figuring out why that’s happening, by exploring the system and piecing together its past. The game certainly doesn’t hold your hand in that, but it’s fair in letting you discover it on your own. I get that this kind of mystery might just not be for everyone, though.

For those not willing to give up on convenience, on Android, there’s Lockdown mode, which will temporarily disable access via biometrics and force the use of your PIN/password to get into your device. Not sure about other brands, but on Pixel, you can enable it by long-pressing the power button and tapping on “Lockdown”.

Not if the site is actually GDPR compliant they are not. You are only allowed to set tracking cookies after consent has been obtained, which cannot be assumed before the visitor has made a choice.

Oh, that sounds really cool! At what time does this validation happen? While you code, or later at build time?

I’m not talking full blown ORM here, not a fan of those either. I’m talking about some light weight wrapper that basically just assembles SQL statements for you, while giving you just a little more type safety and automatic protection against SQL injection, and not sacrificing any performance. I’m coming from the JVM world, where Jooq and Exposed are examples of that kind of thing.

As the other commenter said, the Jetbrains IDEs do this perfectly fine. Although I’d also argue that if you’re working with SQL from within another language already, a DSL wrapper is probably gonna be the better way to go about this.

Well then use all-caps keywords whenever working on those systems, I don’t care. But an edge case like that shouldn’t dictate the default for everyone else who doesn’t have to work on that, that’s all I’m saying.

My ide isn’t limited to color when it comes to highlighting, so being color blind generally shouldn’t be a problem. Set keywords to underlined, bold, italic, whatever works for you.

Your other examples I can see, but at least at my work those are rare edge cases, and I’d rather optimize for the brunt of the work than for those. Of course at other places those might be much more of a concern.

I understand it as an attempt to get very basic, manual syntax highlighting. If all you have is white text on black background, then I do see the value of making keywords easy to spot by putting them in all caps. And this probably made sense back when SQL was first developed, but it’s 2023, any dev / data scientist not using a tool that gives you syntax highlighting seriously needs to get with the times

What exactly do you mean by “trust”, here? Yes, it’s not fully FOSS, and I do understand why you wouldn’t like or use it because of that, but you can still verify the code, compile it yourself and build and run it with your own modifications, so how would being fully FOSS make you trust it more?

I think what they’re talking about is buying online without physical media, but still owning what you bought, as in, the actual movie, as a file on your disk. Best of both worlds - no plastic, no servers necessary for playback after a one time download. That is how things should work.

Never heard of that, thanks for bringing it to my attention!

Makes sense, thanks for clarifying!

How can I find your public key without going through a channel that could also have been manipulated by the admins, though? That seems problematic to me

Also, what’s up with controllers dropping face button colors? The PS5 did the same thing.

From an aesthetic standpoint it just looks better^1 , and by now gaming consoles are so Mainstream that the additional accessibility the colors offer is not a good enough reason to keep them anymore.

^1 subjective, of course, but if you look at modern, big corporate design a lot of it is trending towards minimalism, very little use of color, etc.