avargas

This. Exactly this.

Apparently with the Ryzen processor, the slots are limited: "The Framework Laptop 13 with Ryzen™ 7040 Series processors has two fully capable USB4 ports, with the back left and back right Expansion Cards slots. The front left Expansion Card slot can handle both USB 3.2 and DisplayPort Alt Mode, while the front right Expansion Card can use USB 3.2. This does mean there is one Expansion Card slot that can't support the HDMI or DisplayPort Expansion Cards, and most OS's will provide a warning if you forget. You can charge your Framework Laptop through any of the four Expansion Cards as well.".

This is borderline a deal breaker for me.

I believe it's Solarized Dark. The font I don't know

One of the best ways I've managed latency with MySQL is basically this:

1) use persistent connections, let the OS handle them and tweak it to allow (both connecting server and mysql server). And never close the connection on the application side. (This could lead to potential deadlocks, but there are ways around it, like closing bad connections to clear thread info on mysql).

2) run the whole thing in a transaction, simply begin transaction or autocommit if allowed (same thing)

Doing so, when you are done rendering the content, flush it and send the correct signal to say nginx or apache to say it's done (like PHP's fastcgi_finish_request when working with FPM), and then run your commit. Obviously used when you can safely disregard failed inserts.

I honestly would. This isn't the first time.

I currently live in Colombia and every once in a while, around 40-60% of packages drop. I noticed it was a peer connection in Miami, and almost all traffic went through there. Even if I went to an Argentinian IP, it would still go up north to Miami and then south (my guess is cheap residential peering connections). Anyways I basically got a server from a provider that bypasses this peer connection, and setup a VPN. When my internet starts misbihaving, I simply connect thru that VPN and it fixes the package loss. You adapt.

A bad sql query wouldn't do that. Look at their site, from the US, it calls cloud functions for a COP to USD conversion, on each place they render a currency (200+ requests just going to their homepage). I think it was built poorly, but that's just my opinion.

I tried so many different tools, mostly trying to avoid paying for a service, but honestly, there's nothing as good and as simple as getharvest.com. Simple time tracking, simple invoice generation and my clients can pay via a credit card (Stripe integration) right away. It's worth it.

ZeroMQ is amazing. A few years ago I built a prototype project for a client that basically was fail2ban but scalable. It monitored nginx logs and broadcasted some information, and workers did the rest. Most of the data was in memory and passed around, and communication was done via ZeroMQ. It was done this way so that we could split the heavy-load components off the server and into workers, and allow the server to simply do it's job: tail nginx logs and act upon ban requests from workers. It was amazing, sadly I never completed it and deployed it on a production environment but from initial tests, it outperformed fail2ban by a lot.

The IPS matte is lovely. I have a touchscreen I impulsively bought and it can't face a source of light directly, or else it's unreadable.

I'm curious why none of the cables go through the Gulf of Mexico into Texas (or somewhere around there)? There are many datacenters around Texas, I'd think it would make sense to have some cables going there to speed things up, or maybe I'm wrong?