Petri – Petri Virkkula

HA Event Processor: Capture Home Assistant MQTT Events and Sync to BigQuery for Model Pipeline

Mar 3, 2026Petri

March 3, 2026 • Technical deep dive & quickstart Meet HA Event Processor, a lightweight, production-ready service that subscribes to Home Assistant MQTT events, stores them locally, and batches them to Google BigQuery for analytics and model training. It’s designed to run on your local machine, inside Docker Compose for development, or in a k3s…

How To Convert Hosts File to Zone Files

Apr 10, 2025Petri

I have been using DNSMasq as my local network DNS forwarders, one reason being the easy to manage dnsmasq.hosts file. I decided to move to unbound DNS server because it has more features. I however wanted to keep the easy maintenance of my IP addresses and hostnames. So I wrote a Python script (with help…