US is also taking leadership in space, which has deep military implications, telecomm and (maybe?) natural resources.

Lastly, it's a big mistake to write-off the US labor force and consumers, who react very quickly to change.

realistically, this device would need to tiny to justify the extra weight, device-to-keep-charged, etc.

one idea: make it wifi-only and tether from your primary mobile device. This skips all the carrier nonsense, to focus entirely on the core use case(s).

This map pretty much proves it!

https://share.gemini.google/1yNVV19wUn46

Three Mile Island was a * big * deal - if that had happened on Long Island, it would've been unimaginable disaster and permanent stain on NYC.

To many people, "three strikes you're out" - 3MI, Chernobyl and Fukushima was the final straw, reasoning that even the Japanese can't safely manage this technology, so "Homer Simpson" stands no chance.

Meanwhile, even the country's leading experts have no politically viable strategy for disposing of the waste, including the risk of derailments, terrorism, etc.

This isn't the world I want, but it's reality. IRL, people would rather die slowly from CO2 than live with the fear of 3MI/Chernobyl/Fukushima regardless of how rare they are (and they're not).

I'm optimistic that modern reactor designs and reprocessing technologies can overcome these issues, but I can understand why voters go full NIMBY.

1. "materialize" the view as a full table, then index that. Any reasonable pipeline/ETL tool can provide incremental updates between tables. Obviously, anything materialized requires considerations around storage, replication, backup/restore, I/O, etc.

2. use a regular VIEW and index (precisely) the underlying expressions mentioned in the view, i.e. so when the view is used, then the indexes get used.

Both require rewriting SQL, though I've used VIEWs to make the change transparent.

can these banks/brokers get hacked?

I'd love to see a way for people to revoke/replace their personal info, kinda like rotating passwords or changing their names - but for street address, birthday, government ID numbers, etc.

Penalties (of any scale) are insufficient to ensure absolute security.

It's all the benefits of a tablet with the weight/thickness of a cell.

Example: maps shows both the map and listing detail.

Example: messaging/email apps show the message/channel list and the current message

Example: virtual keyboard has plenty of space for punctuation, emojis, etc.

Example: games and multimedia are perfectly pleasant to view, even for hours.

Example: I used the remote-control app to take photos from my Sony and Fuji cameras, and the live preview was large enough to easily check for tack-sharpness, which is hard even in the camera viewfinder.