Self-Hosting6
Running ClickHouse on a Dedicated Server, Backed Up Right
Why I run ClickHouse on a dedicated box instead of Kubernetes, the trade-offs, and how to back it up without corrupting your MergeTree parts.
A Self-Hosted Modern Data Stack Under €200/Month
How I ran the modern data stack — ClickHouse, dbt, Dagster, Iceberg — self-hosted on Hetzner for under €200/month instead of €1,000+ managed.
Auditing an Open-Source Ecosystem: 1,434 Repos
A reproducible recipe for checking whether an ecosystem is as open as it claims: the GitHub sweep, the filter matrix, and what a licence check finds.
Rebuilding Home Assistant From Backup: a Timed Run
I rebuilt my Home Assistant host on a fresh VM with a stopwatch. It took about 50 minutes, and two steps were missing from every backup archive.
Backing Up Home Assistant: the Config Folder Isn't Enough
A config-only backup restores Home Assistant but not the host: VPN keys, firewall, cron and the container definition belong in the archive too.
dbt on ClickHouse: Project Layout and the Gotchas
How I structure a dbt Core project against ClickHouse — staging/intermediate/marts, layer-per-database, incremental models, and the ClickHouse-specific gotchas.