Elasticsearch ES|QL: Energy Consumption Chart With Home Assistant Data

Elasticsearch ES|QL: Energy Consumption Chart With Home Assistant Data
Elasticsearch comes with multiple query languages, only one of which makes sense to use for time-series data as ours: ES|QL. It’s obviously modeled after Splunk’s SPL, is easy to read, understand, and write - helped by fantastic autocomplete in the web UI. This article explains some important ES|QL concepts by showing you how to create a chart that visualizes your home’s energy consumption.
Home Automation, Networking & Self-Hosting

Elasticsearch: Long-Term Storage of Home Assistant Data

Elasticsearch: Long-Term Storage of Home Assistant Data
This article describes how to send Home Assistant metrics to Elasticsearch for long-term storage and visualization. It focuses on the integration between the two products and on how to configure Elasticsearch. This post is part of my series on home automation, networking & self-hosting that shows how to install, configure, and run a home server & network with dockerized or virtualized services.
Home Automation, Networking & Self-Hosting

VictoriaMetrics: Long-Term Storage of Home Assistant Data

VictoriaMetrics: Long-Term Storage of Home Assistant Data
This article explains how to set up VictoriaMetrics in a Docker container with automatic HTTPS via Caddy. It also shows how to forward Home Assistant data to VictoriaMetrics for long-term storage and how to query the data from Grafana. This post is part of my series on home automation, networking & self-hosting that shows how to install, configure, and run a home server & network with dockerized or virtualized services.
Home Automation, Networking & Self-Hosting

Docker Monitoring With Prometheus, Automatic HTTPS & SSO Authentication

Docker Monitoring With Prometheus, Automatic HTTPS & SSO Authentication
This article, effectively part 2 of my Grafana setup guide, explains how to set up Prometheus, Node Exporter, and cAdvisor with automatic HTTPS certificates (via Caddy) and OAuth single sign-on (via Authelia). This post is part of my series on home automation, networking & self-hosting that shows how to install, configure, and run a home server & network with dockerized or virtualized services.
Home Automation, Networking & Self-Hosting