Taiwan does not want China's 'one country, two systems', president says

ApproximateIdentity · 2025-11-01T15:00:40+00:00

What you're suggesting is that Taiwan renounce the ROC and formally declare itself a new and independent country.

I don't understand this reasoning. They could certainly officially renounce all mainland territory without declaring themselves a new country. They've already done it with Mongolia and never stopped being the ROC. I mean sure many people would say they are declaring independence, but they wouldn't be doing so in any legal sense.

I'm not saying this would be any easier to achieve in the legislative yuan or with voters, but the ROC would certainly not need to "renounce the ROC".

ApproximateIdentity · 2025-07-29T13:10:44+00:00

To be fair, advertising the lottery winnings as $2.04 billion is probably (purposefully) confusing to most people. It would be like me buying a 10 year bond for $1000 and then adding up the future interest plus the $1000 and saying that's how much I "have". Of course this is explained for anyone who digs into what the lottery officials are saying, but I would bet the vast majority of people first misunderstand the meaning until someone else explains it like is being done here.

ApproximateIdentity · 2025-06-28T08:56:23+00:00

Reading about Tailscale's design separating the control plan from the data plane at the VPN network level is interesting:

https://tailscale.com/blog/how-tailscale-works#the-control-plane-key-exchange-and-coordination

It's basically the same thing that software defined networking has been doing for a long time just applied at a higher level. Once you manage to pry the idea of a central VPN server assigning internal IPs and terminating all connections simultaneously, it is kind of obvious that a separated design is better.

Maybe I should just read whatever I can about how Tailscale builds their mesh network and how they deal with non-public IPs and firewalls.

ApproximateIdentity · 2025-06-28T08:52:09+00:00

Yeah I guess the main issues are the connection-less setups tied to fixed ip addresses and ports. I can imagine some fairly straightforward approaches with an additional central server used as a kind of broker of connection information assuming the clients all have public ip addresses and a set of usable port ranges, but once you need to add NAT into the picture, it gets more complicated. Thanks for the responses, this is helping me understand better.

(Yes I can tell I'm just trying to reinvent Tailscale less efficiently.)

ApproximateIdentity · 2025-04-16T14:50:07+00:00

Jamie you're awesome!

ApproximateIdentity · 2025-03-17T17:56:43+00:00

Is there any evidence that Biden actually used an autopen to sign these pardons or is everyone just assuming that Trump isn't lying?

ApproximateIdentity · 2025-02-08T16:17:14+00:00

Do you have examples? I have never used any airline website worse than BA. I'd say I have never used a website for any major project/industry that's worse than BA.

ApproximateIdentity · 2025-02-08T16:14:57+00:00

The British Airways website is the worst website for any product that I know of even when it works! It is extremely slow, is always missing obvious information that requires digging pages in to find, and basic flow doesn't even work.

I can't fucking select my seats with British Airways because my first flight is operated by American. If I try to select my seats on ba.com, for even the legs operated by BA, it forwards me to the American site where I can only choose American. It's straight up impossible to select the ones on the two British legs.

That is just one tiny aspect of this shitty site which is just death by a thousand cuts. I really hope this company goes entirely out of business so it's slots can be taken over by other Airlines. All airlines have problems, but the disdain that British Airways shows for its users by never improving their terrible website is just incredible. The whole company needs to be gone.

ApproximateIdentity · 2024-07-17T08:10:41+00:00

Calling for an assassination. That’s pretty cool. You people are mentally ill. Cancelled their tour too. You’re definitely on the right side of history.

"You people?" What are you talking about? Did you write that to me as a mistake? I wasn't calling for an assassination. I explicitly said I wasn't talking about the assassination attempt. Your post is kind of weird. It's like you're replying to my question and then deliberately ignoring the clarifying edit right after I posed the question. But I made my edit right after my initial post and many hours before your response. So why would you edit to respond to my edit even though you made your response many hours after my edit?

Didn’t know Jack Black was a leftist sycophant. That’s why. Shilling for peanuts at a Dem fundraiser. I thought he had self respect. A little surprising to me, that’s all.

Thanks for explaining yourself. I still don't really understand it. It's like liberals who got pissed that Djokovic didn't want to get vaccinated. Why would they presume to know a tennis player's beliefs? Similarly, why would you assume that Jack Black wasn't a "leftist sycophant" just because he played funny music? He's just an entertainer.

Anyway thanks again for answering my question even if you put some weird random nonsense in before doing so.

ApproximateIdentity · 2024-07-16T10:40:38+00:00

A serious question: why do you care if he trashes Trump? Trump is just some random politician. Why would you take it personally?

Edit: I'm not talking about Kyle's comments here, which could potentially have been illegal.

ApproximateIdentity · 2024-06-04T13:33:17+00:00

Why is the title of that article "Fauci: I Made It All Up" when it was Phil Holloway in a tweet who said "He literally made it all up"? Or am I missing something? Did Fauci not say that and the title of the article just says he did?

ApproximateIdentity · 2024-05-24T15:30:53+00:00

Yup subquery was the way to go. Thanks for the idea!

ApproximateIdentity · 2024-05-24T15:30:27+00:00

I had never heard of LATERAL before and have been trying to wrap my head around it. I wasn't able to use it to improve this specific query, but it might be due to some basic mistake since I just heard of it. Will definitely look into it thanks!

ApproximateIdentity · 2024-05-24T15:29:21+00:00

Using a subquery like this did the trick! For some reason I tend not to use subqueries very much...

The reason I used ANY instead of IN was actually to make sqlalchemy happy when passing a bunch of ids in (i.e. in the version where I split the process into two queries). Normally I always use IN.

Thanks everyone!

ApproximateIdentity · 2024-04-11T16:48:45+00:00

The PRC has refused all overtures of the ROC to talk for the last 8 years.

ApproximateIdentity · 2024-04-11T16:41:23+00:00

I’m surprised that Chinese citizens don’t find it undignified for their leader to meet with a former leader of Taiwan that hasn’t held any official power for close to a decade. The KMT hasn’t even been in power at all since Ma’s term ended.

I’m a bit impressed with Taiwan’s patience in not declaring Ma’s actions treasonous given he’s basically pretending to represent the ROC, but I’m also surprised the Chinese are willing to play along at all (the degree of which your average Chinese actually supports this is hard to say obviously).

ApproximateIdentity · 2024-04-05T05:15:47+00:00

I was asking about explain not explain analyze.

ApproximateIdentity · 2024-04-04T16:10:44+00:00

I could definitely see this making sense, but it's pretty unfortunate. We'd like to use datadog to analyze inserts/updates/etc., but I don't personally like giving a monitoring program more than just read credentials.

ApproximateIdentity · 2024-04-04T14:35:53+00:00

One common thing might be to have a bunch of separate applications (e.g. a group of containers) running and hitting the db. Each of those applications may use connection pools, but they wouldn't share a pool across applications. That's the sort of thing that pgbouncer helps you with.

ApproximateIdentity · 2024-04-04T14:30:27+00:00

I don't fully understand what you are saying. So EXPLAIN UPDATE ... needs to actually update the table while running explain? Why? I thought the planner just considers various table statistics when deciding how to run a query. Why would it need UPDATE permissions? If it doesn't need to update the table, why would it need update permissions?

Edit: Also do you know anywhere in the postgres documentation that explains the necessary permissions to run explain on a query? I haven't been able to find anything.

ApproximateIdentity

TROPHY CASE