Firefox added a layer on top to allow to show the list of profiles in the UI.
I recently started a new job and built 3 profiles on Windows, then switched to Ubuntu. The migration of my profiles was painful because of that new layer: migration of each profile was working fine, but didn't see each other.
Thankfully Claude was helpful to debug and fix the settings. I had to edit SQLite databases.
Counterpoint: each new edition will add bloat to SQLite as future edition will need to keep each past edition pragma set for backward compatibility.
As SQLite is often used embedded, bloat matters.
So I suggest that "PRAGMA edition" to be only be a shortcut to a list of PRAGMA commands, that would be expanded at the library level: PRAGMA edition would never appear in the DB file. As such, the build of the library would just support a limited set of editions, with a removal policy in default builds. Maybe editions could even be defined at runtime (a system table?) as a way to load them dynamically if old editions are needed beyond builtin support (think about the state of SQLite in 2046).
From a previous preprint titled "Claude’s Cycle", dated 2026-02-28 [2]:
It seems that I’ll have to revise my opinions about “generative AI” one of these days. What a joy it is to learn not only that my conjecture has a nice solution but also to celebrate this dramatic advance in automatic deduction and creative problem solving. I’ll try to tell the story briefly in this note.
I discovered a few years ago that a such a wind tunnel facility existed in my area (France), but at a smaller scale. I had the opportunity to visit it. The facility is about 100 years old. What amazed me is not just the facilities (they have various tunnels for different measurements), but how it adapted to customer usages through time as engineering needs evolve. One building was initially designed for seaplanes but has long ago been refurbished for other uses. Another one is used by the French cycling team which has headquarters nearby.
The resason is that only Google bothers to put enough hardware security features to build software on top that allows to make a really secure device that blocks tampering.
EA still hasn't made its EA account malware SteamDeck compatible. I have to spend 30 minutes every few months to enter again my EA account credentials (nowadays I use a dock and a hardware keyboard).
If you pay a premium price, you're an even more interesting target for others premium brands, so the best target for advertisers. And they are too greedy to leave you alone.
This is becoming a thing in computing because sovereignty suddenly matters in the new context.
France pushes its SecNumCloud standard for critical infrastructure or handling of critical data (ex: health) through law.
So, this may not be about pride, but the result is similar.