My only experience with versionitus type things is with microsoft sql and other "enterprisey" things that used it and its hard enough without huge upgrade blockers like text in an integer field lol still they're willing to add the default to the table create statement. I'm thinking that sqlite folks feel that things like type safety, database consistency are disliked authoritarian attributes, and I'm sure thats a consideration in letting old code touch databases that old code doesn't understand.

Its wierd that they didn't like having a pragma for any new table creation even at the database level but they allow this problem factory:

  "Because of a quirk in the SQL language parser, versions of SQLite prior to 3.37.0 can still read and write STRICT tables if they set "PRAGMA writable_schema=ON" immediately after opening the database file, prior to doing anything else that requires knowing the schema."

I guess for ID reuse a rationalization could be that theres only so many integer values that can fit into a certain number of bytes haha

Now as I've thought this through some, I could see where selected networking could be made kid friendly, you know, like a top level dns where you need to prove yourself to be underage or heavily vetted adult with id verification, and this entire tld could be made kid friendly. I don't doubt that most of today's dns infrastructure is probably not up to the job, but a very tight and heavily vetted registry for .kids for example (or maybe better as kids. as laws vary) would solve all of this. Make a subset of the internet kid safe and serve the kids that.

The fact that all these proposed laws still give kids general tcp/ip access at the physical level means we do conclude exactly what my parent commenter says, its not really about the kids, its about the free and unfettered flow of information that must be stopped. In the US, its getting close to illegal to disseminate information but once factual information does indeed become criminal in nature, you need to catch the perps and thus the IDs attached to packets of fact carrying information.

"Recent economic research links the rise of smartphones to the persistent decline in birth rates. A National Bureau of Economic Research (NBER) study estimates that early smartphone adoption accounts for 33% to 52% of the drop in the U.S. general fertility rate, particularly among teenagers and young adults under 30"

-- this quote is from AI and could be a complete fabrication

I'm not against kids having some sort of child friendly network access. The trouble is that there is no tech that is child friendly any more, its all vibe coded crap that keeps no one safe at all anymore with hidden traps inside the cesspool of crazies posting all sorts of wierd crap conspiracy shit.

Heck a super beneficial appearing thing like wikipedia is literally an encyclopedia yet the GOP for instance can't stand it if someone talks about any sexuality at all or some other bogyman subject of the hour.

Just ban kids at the internet's points of entry. Phones, Modems. Age gate amateur radio too, no kids interested in amateur radio anymore anyways, no packet switched communications at all until 18 or whatever.

Why is letting your kids sext with adult strangers any different? Is it because the only "pimping" you are doing is giving in to your brat nagging for an iphone?

Why are we pushing our kids onto the internet? There is nothing there for them. Any politicians pushing for kids internet access are probably doing it for nefarious reasons in my opinion. The internet is not really all that safe for adults either, why are we pushing kids onto it?