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 !clickhouse@programming.dev

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.

The screenshot isn’t real though

They’re not found in traditional PC’s and are attached directly to the motherboard itself. They’re meant for mobile / embedded but are quite popular for servers in the selfhosting community due to their low power usage, price, and performance. It’s comparable to a i5-7500T in terms of performance (so not that fast), but it does have better video encoding acceleration which makes it suitable for streaming video. Due to the availability and prices of Raspberry Pi kits, these are often chosen instead for simple servers because mini-PC’s with it can cost the same as a Raspberry Pi kit.

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.

The N100 goes up to 3.4GHz and has a TDP of 6W

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.

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

I tend to pick D, the instance that is federated with most other instances so most of the interactions are visible or C.

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

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

I also use them but I often get blocked from sites when it’s on