I’ve been using ClickHouse too and it’s significantly faster than Postgres for certain analytical workloads. I benchmarked it and while Postgres took 47 seconds, ClickHouse finished within 700ms when performing a query on the OpenFoodFacts dataset (~9GB). Interestingly enough TimescaleDB (Postgres extension) took 6 seconds.

^{All actions were performed through Datagrip}

^{1 Insertion speed is influenced by reduced networking overhead due to the databases being in-process.}

Updates and deletes don’t work as well and not being able to perform an upsert can be quite annoying. However, I found the ReplacingMergeTree and AggregatingMergeTree table engines to be good replacements so far.

Also there’s [email protected]

I can attest to that. It’s remarkable on how few distros updating through Discover actually works reliably. I always update through the terminal because at least that works. I’ve noticed this issue on Kubuntu (apt), Debian (apt), and OpenSUSE (zypper). I think these issues are related to the PackageKit integration.

I made a tool for this some time ago. It detects when programs write to your home directory outside the XDG spec and logs the file and the location of the binary that wrote it to an SQLite file.

Considering your budget of 200 GBP / 250USD, I would recommend laptops meant for school. There are plenty of refurbished laptops out there with a decent battery condition and overall state for sale around €100. Most of these machines aren’t more powerful than most entry level Chromebooks and often have a Pentium or Celeron CPU, but that’s a tradeoff you’ll have to make. Another advantage is that they usually come with a touch screen and decent display, which is nice if you’re out and about.

sub 200 GBP / 250USD I guess

Last time I checked most were starting at 700+

If you want to expose it publically for others to use consider using Cloudflare for easy setup and avoiding exposing your home IP. If you want to use it for yourself you can access it with Tailscale and forward traffic to certain ports based on the subdomain using Nginx Proxy Manager.

It’s still AGPL afaik

EDIT:

This project is available under GNU AGPL v3 license.

Still is

Have you considered that the machine is made by a collection of humans?

Same, I have about 40 devices on my network and it works great

Yes, but I still don’t know why they seem to think it’s so important to write a new browser engine instead of improving Gecko or Servo. To me it just seems like people like it because they don’t know other things aside from the Chrome, Safari, and Firefox browser engines exist and just chase something new and shiny.

And obviously their option is the “best”. From the conclusion:

Talos Linux is unique. It’s the only option that includes OS management in a purpose-built distribution for running Kubernetes. There’s no compromise for scaling up or down. In terms of small-scale numbers, it “wins” in several of the examined categories, including memory usage, disk r/w, and installation size. But all of these metrics are side effects of Talos Linux’s defining characteristic: It’s simple.

The fact that it’s aiming to be stable doesn’t mean it is. It’s still a work in progress unlike other browsers.

FYI you can get a numeric xyz domain for 1$ a year

…definitely takes some getting used to when you come from a non-memory safe language…

I actually think it’s more like the opposite. The compiler takes the normal rules you apply to avoid issues with a non-memory safe language like C/C++ and enforces them explicitly where memory safe languages don’t have those rules at all. I think lifetimes are much more confusing if you’ve never dealt with a user after free and usually let GC deal with it.

Also yes the compiler warnings and errors are amazing, the difference between rustc and gcc is night and day.

It will become more complex when you start needing circular references in your datastructures.

It’s only intended to be used by the program itself. It’s purely storage.

Thanks for the advice, but this is just the format of some eyetracking software I had to use not something I develop myself

It’s used to export tracking data to analyze later on. Something like SQLite seems like a much better choice to me.

Windows with the most popular chrome version to avoid standing out

My server is in a closet without ventilation. You will probably be fine.