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

Aren’t they a berry?

In case you don’t know who she is, she’s the founder of Elementary OS

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.

But Mamdani won and Cuomo lost the primary?

Looks like Tumblr

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

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

Some person was showing me videos of him and telling me he was very smart, does anyone happen to know some good examples to get him to reconsider?

No that doesn’t seem to be it. Thanks for trying anyway.

When the program is running it’s probably stored with 32 or 64 bits, but that probably isn’t the case for the network packet layout. I can imagine them wanting to optimize network traffic with over 3 billion users even if it’s just a small improvement.

Also TIL that Erlang’s VM apparently stores strings as linked lists of chars. Very strange.

As the numbers guy. Do you remember the name of the site that can tell you the what a given number is often associated with?

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.

Why did you share this?

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.