tomnipotent

For cloud databases, in your use case do you care that the queries actually execute or only that they parse? I with every cloud service had their own version of LocalStack/Moto, and while not perfect they've really helped to improve test coverage.

All of their crime rates are lower than the US across all categories, except maybe bike theft. The US has anywhere from 4-10x Japan's rate of sexual assault crimes (the lower end accounting for their lower report rate).

Agreed. Almost every submission has someone claiming it's AI now, it's pretty exhausting.

They've always billed monthly, but the thing they got in trouble for was that it was attached to a 1-year commit where customers were getting hit with early termination fees pro-rated to the rest of the contract. If they did offer this it was hidden deep in the sign-up flow enough that they lost a lawsuit over it.

> discount for committing to a year

It's worse than that. They don't even offer a monthly subscription contract - it's purely annual, but they advertise and promote monthly with fine print.

I imagine both states would end up with single-payer healthcare pretty quickly, and both already have GDP greater than all but 3 EU countries... what exactly would the EU bring to the table?

There are a few bad examples like Halo, Black Flag, and Oblivion but overall I think remakes/remasters over the last several years have been pretty good. Resident Evil, Silent Hill, Dead Space, Persona, Final Fantasy Tactics, Gothic, Super Mario/Paper Mario, and Tomb Raider all come to mind.

Regardless, IP holders should have the rights to distribution and while you may disagree with that it's still a legal protection they get to enjoy under our legal system.

I just re-installed recently for gaming partition. Some of the things I need to disable are annoying, but yes they're still fine.

> fighting against the annoyances

Because they're trivial annoyances. I spend just as much time disabling or changing annoying things on KDE (or MacOS), I don't see the difference other than "Microsoft bad!" At the end of the day the same amount of my time is wasted. I'll save my moral outrage for actually important things.

And these VBA macros in excel probably don't have any more bugs and issues than all the software written by the HN community. Six of one, half a dozen of the other.

Except they pay CodeWeavers to do most of the work.

> maximize clicks and screen-time

This doesn't make any sense. I regularly use Windows for a few things, and do not have this problem. Sane corp group policies disable all the annoying things folks complain about on the default consumer install, and there are few things you can't do just using a keyboard and keybindings.

I still prefer Linux and KDE is my daily driver but most of the comments I read here about Windows seem to be people regurgitating second-hand comments they read and passing them off as their own, and it's always the same small list of things every time.

> only really works well for a couple of query patterns

To be fair this probably covered probably 9x% of production queries, like high-selectivity index-covered filters and sorts (with a limit). Even today most planners will still use an inner loop.

It's been interesting to watch how different planners have evolved over the years. SQL Server 7 in 1998 launched with features that MySQL and Postgres wouldn't catch up to until the late 2010s, but they had other features and quality-of-life improvements that made these edge-case optimizations hardly noticable.

I think OP is just alluding to the fact that Postgres needs to do less work to go from secondary index to table data, since the tid is a direct pointer to the exact page and slotted entry while MySQL needs a b-tree walk.

> primary key index will be mostly cached so the cost of the indirection is much smaller than it may first appear

Not sure I follow. If it's in-memory you save having to read from disk, but you still have to walk the b-tree to go from PK to data.