asah
1. fold is godsend for commute/travel/restaurant/club/etc. tablet is nonstart. 2. one device = one device to learn/optimize.
also, there's something deeply elegant about starting with the outer screen for quick stuff, then unfolding when it's gonna be a minute...
I'm in nyc, and it's delightful to use slab-mode standing up, then sitting down and unfolding, like it's a Harry Potter moving newspaper...
Also, showing off my photos on the fold is a joy.
yes, battery & camera are a generation back and water/dustproof is even worse.
but productivity and fun are off the charts: slab phones feel pathetic once you've got a fold. Communication apps show you the list of conversations as well as the current one - or the current one and the details/multimedia. Google Maps shows the map and the listing details/reviews. Games and multimedia are delightful. Photos are full sized, and you can see what you're shooting in detail - if you shoot with a digital camera, remote shooting is amazing because there's enough space to show detailed focus.
- early social media really struggled to scale the social graph algorithms. Facebook made real technical innovations.
- early social media had serious problems with trust/safety and really nasty content. Many complex problems from deeply adversarial userbase.
Together, Orkut got bogged down and couldn't compete for resources with ads/search/maps/etc.
This saves a __lot__ of headaches, of which timestamp vs timestamptz is the tip of the iceberg.
as is often said with a sigh, "democracy is the worst form of government, except for every other."
to me, democracy is really about giving the masses enough feeling of agency, because the alternatives are either revolution and/or disengagement / low productivity / low creativity, and both are "bad for business" i.e. cannot compete with democracies.
China will be an interesting test of this theory. Notably, in China they have a terrific education system and the government is able to attract/retain smart ambitious people.
Another test will be the power of governments to thwart revolutions using digital and kinetic assymmetry. The masses have individual hackers and pea shooters and the government has digital armies and autonomous drone swarms. In turn, since revolution is off the table, governments don't need the overhead of democracy. In the US, we see this with the rise of Executive Orders for example.
it works because 99% of the time you don't need fast latency because you can accurately predict things.
that's why a standard recommendation is to drive 2+ seconds (time not distance) behind the car in front of you. also why experienced drivers instinctively move their hands/feet into position during tricky moments when they need to cut the latency.
fun exercise, try taking your foot off the gas and hitting the break - slower than you think!!
Iran has repeatedly called for "death to America," "death to Israel" and so on.
Israel's leaders do not generally call for the destruction of other countries.
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!
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.