Seafile + Samba + OpenVPN is my stack. I use Seafile for a dropbox style file sync on my devices, and Samba for direct access. OpenVPN for remote access on all devices. Works quite well.
I didn't follow the whole session (only saw the memes about it on TikTok), but in the recent congressional hearing, was the TikTok CEO grilled on misinformation on his platform? I see tonnes of astroturfed content on TikTok, significantly more than other platforms. Russia bots, flat earthers, moon-landing deniers, 9/11 truthers -- obvious misinformation. I've reported these before under misinformation but the report is usually rejected. Does TikTok turn a blind eye to these things, or is it the nature of the algorithm that I'm exposed to more content outside my "bubble"?
I recommend this method for self-hosting too. I have gigabit Internet and cloudflare proxying unlocks the ability to host locally without exposing my home IP. Plus all the advantages of DDoS mitigation.
I agree with the general sentiment of this & wish I had a better view. My office is currently in my basement (only practical place in our house for it). I probably spend around 60% of my working hours there, the other 40% I'm on my laptop in various locations around the house to keep it fresh.
One thing I've found to help is growing some plants indoors. I have a few grow lights on 12h timers that keep me a little grounded to the rhythm of the Earth. However nothing beats the energy you get from a natural view.
While I didn't do this myself, I remember watching Kevin Rose do this on his internet show thebroken. He talks about getting an orinoco PCMCIA wifi adapter because of their broad support for this kind of thing. If you want a blast from the past, you can watch them here: https://archive.org/details/thebroken_xvid
I know Minio can be used for production workloads, but Minio as a localhost substitute for an S3-like store is underrated. S3 dependent projects I work on spin up a Minio instance via docker-compose to get a fully local development experience.
"Near-path NAT"[1] has been suggested as a mechanism that browsers can use to proxy requests through an intermediate server, similar to what you suggest.
Helps if you only have one platform you're developing on and deploying to (e.g. x86-64 Linux). If developing on macOS there can be Mac specific binaries installed, depending on the package.
I'm thinking more of an Irradiance map where the value is the current W/m^2 at a specific location, which would take into account latitude and time of year (to get the angle of the Earth relative to the sun), along with other factors like clouds, altitude.
Interesting that these maps are always binary: light or dark, when the intensity of light varies based on how high the sun is in the sky. Is there a version of this map that takes that into account?
Normalizing has similar size benefits. For our use case (big aggregate reporting tables), incoming external data is not normalized, meaning we'd have to have another process iterate over it with foreign table in memory and map it to the foreign key. Enum's can be transparently ingested without this normalization requirement, while taking equivalent space. There's also now one level of indirection between the column and its value. Both are fine.
This is a common operation for my team as well. In my old project, so many indexes that were added were just assumptions about the usage pattern of the data. Not only did they blow up the size of the table and INSERT time, they became the opposite of a red-herring where developers would stop and look elsewhere because the table "already has indexes".
Only adding indexes with good use of EXPLAIN/EXPLAIN ANALYZE on expected usage patterns yielded good results. Often we'd just blow the indexes away and fiddle until we added the correct one to enable an index scan / index only scan.
Other big boons for us have been using ENUM types where necessary (small known dataset for a column) -- now your column takes 4 bytes instead of N bytes for a string. I find them a bit easier to work in than foreign keys for this optimization because of their direct string mapping.
We've had really good mileage with Datadog's APM tools, RDS performance insights and pghero as you mentioned.
One of my favourite things to do on Slashdot during its heyday was go through the comments and open all the "Homepage" links from user profiles. It was usually a treasure trove of personal websites in this style.
UCI chess engines typically defer opening book to the GUI consuming it. So if you were using Stockfish with Arena or Tarrasch, that would handle the opening book. Stockfish will start calculating when it is out of the book. This is all configurable, of course.
