Self-Hosting5
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.
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.
What AI Crawlers Actually Do to a Small Blog: 9 Days of Logs
Nine days of nginx logs from a small blog: 18,209 AI-crawler hits. Which bots (ChatGPT-User, Bytespider, ClaudeBot), who honours robots.txt, and the JS-less view they actually see.
Solar Surplus into Hot Water: the AC·THOR in Home Assistant
I wired an AC·THOR 9s into Home Assistant to dump PV surplus into the hot-water tank — then the device refused every Modbus write. Here's the read-local, write-cloud fix.