The SQLite docs have a section about it, the idea is:
1. Create new table with foreign key constraint
2. Copy data from old to new
3. Drop old table
4. Rename new table to old name
Seems like essentially the same threat vector as with NPM.
Not quite related: I never heard of clawdbot before, so, I guess TIL that's the bot my website keeps getting requests that are obviously malicious from.
You're entirely right, but they need to maintain Windows in order to promote those services. The OS and their various applications have a symbiotic relationship where they prioritize each other.
If Microsoft discontinued Windows and switched to just providing web apps, the competition would be a lot stiffer.
They literally tried that strategy with Internet Explorer 6 a long time ago where they didn't really update it for years, only doing the bare minimum. The result was a downward spiral in market share that they were unable to stop once they started trying again, ultimately resulting in IE effectively becoming obsolete.
Because browsers are one of the very few components that actually need to catch up to the rest of the world, but they've already outsourced most of that work to Chromium.
If this is the case, Windows seems like it should be very important. Otherwise they can't deliver their subscription services. I'm not going to subscribe to cable TV if my TV is broken.
