That makes sense because pypy can JIT a ladder of if/else to a compare/jump conditional each whereas a dict lookup can be an order of magnitude more complex. If they're 8bit opcodes, maybe having a list based lookup table will perform similarly on py3000 and still optimize on pypy?
This is true, on average having an edge will be faster, but it is not a panacea for latency, especially if you don't move non-trivial QPS from every region.
It's more complicated than that though, you're interrupting a rape, in the victim's house, the perpetrator is their neighbor and they have a gun (so do you) so bloodshed is imminent if you get involved, you're the victim's significant other, but you don't care that much about them, you've been beefing with the perpetrator over who gets to store their car on the victim's lawn. The rape should stop and the perpetrator punished, but it's still not clear who gets to store their car on the victim's lawn (what you care about). You really want the victim to off their violent neighbor so you slip them an icepick and slip out the door.
Right, my camera even goes as far as offering in-body HDR, it's just not as good as what I get in my iPhone, especially when the scene has moving elements, the camera isn't on a tripod, etc. Phones can paper over a lot of things with "AI" which means that you can get a serviceable shot without trying, but it doesn't really correspond to reality and sometimes (especially with the moving elements case) has artifacting.
I imagine they love the sqlite codebase but are not ecstatic about having to maintain a fork and would like to have sqlite upstream their changes such that they don't have to import patches in perpetuity. This is a valid frustration that most commonly happens with OSS that's built by a corporation and thrown over the wall. I think in this case the dig at the end of the README is a way to be like "look at those religious cult members, closed off from accepting contributions" which is a cheap shot but all's fair in politics. A lot of companies build on top Linux, PG and others and are able to reach consensus with the community.
I think making sqlite distributed-capable is very interesting. Postgres isn't trivially distributed and is a full fledged database server that's not appropriate for scale to zero workloads, though others are working on that as well.
Do know that if and when they do, they'll question your StarVPN IP. Time to pay someone you know to keep a second glinet router in their home in the state you're supposed to be in.
Yes, the easiest way to do this is buying 2 routers that support a VPN server and a VPN client. Any OpenWRT capable router should be able to do this for you, gl-inet built a business by selling routers with custom OpenWRT-based firmware with a streamlined UI for exactly this: you log-in go to the tab for configuring the OpenVPN/Wireguard server/client and you have yourself a private tunnel.