1, complicates and slows down update, which is typically more important in OLTP than OLAP

2, is generally bad for high cardinality columns, which requires tracking cardinality to make decisions, which further complicates things.

lastly, additional operational complexity (like the table maintenance system you described in last paragraph) could reduce system reliability, and they might decide it's not worth the price or against their philosophy.

The fact that people believe in journalistic integrity shows how successful they are at brainwashing the public.

If, let's say, a typical $30k car means a large EV SUV with all the luxury gadgets and conveniences, plus fridge, massage chair, full camping setup, etc. Would 30k car buyers not expect those things?

Is that the reality? or is it middle class and less advantaged white/asian kids giving way to middle class black/hispanic ones? Or worse, is it simply raising the bar for asians because there are too many of them in higher education like they did to jews?

A good example is that google is banned but bing is not, and tiktok is also banned in China because they don't follow those laws.

Sanction means those uncompetitive local startups don't have to compete with established players, giving them chance to catch up.

It seems the author actually understands the local customs, but couldn't accept it emotionally.

The problem is sadly much more complicated than "dictatorship wants to subjugate democracy". Simplified thinking is what the elites from China, Taiwan and the US wants you to think, so powers can be held onto and wars be justified.

Chinese people from mainland cares much less about democracy than citizens from western countries. The primary motivation for Chinese people to want reunification is that it's one of the last remaining symbols of colonialism.

It serves similar purpose as opening firewall to just a specific IP/port and dynamically change the IP/port as the other machine moves or disconnects. One of the main advantage is that it works behind NATs you don't control (i.e. public WiFi).

Edit: also most home routers do not have the ability to dynamically open up to specific IPs based on where your outside machine is.

For those who don't have time to read, Tailscale uses a quirk in how stateful firewall treats inbound UDP traffic to allow connection to a remote server without it opening up to the public.

The employee market does penalize generalists, those who lack political savvy (ADHD, OCD), and/or those who do not come from well off families and connections.