06

Nov/23

MariaDB/MySQL Database Size Sensor In Home Assistant

Filed Under Database, Home Automation at 6th November 2023 0:01 by

A quick little tip to get the size of your database into Home Assistant. The example below will get the Home Assistant database size from MySQL. This should also work for MariaDB using the Recorder integration. Assuming the database schema … Continue reading →

07

Aug/23

Salt Level For Water Softener With ESPHome

Filed Under Home Automation, IOT at 7th August 2023 0:01 by

overview We got a water softener installed near the water mains coming into the house. It’s a “dumb” softener so that it does not rely on using electricity. This means it will continue to work in a power outage but … Continue reading →

01

May/23

Home Assistant Continuous Integration Workflow 2023

Filed Under Home Automation, Workflow at 1st May 2023 0:01 by

Overview Previously, I was using TravisCI to perform checks on any changes to Home Assistant files. Since then, TravisCI has introduced caps and pricing plans and on the free tier I ran out of credits very quickly which broke the … Continue reading →

06

Mar/23

Central Heating Graph With Home Assistant

Filed Under Blog, Home Automation at 6th March 2023 0:01 by

Overview I have created a graph to show temperature for each room in the house broken down to level/floor they are on so I can see how well heated each room is. I don’t have any smart thermostatic radiator valves … Continue reading →

07

Jan/23

Home Assistant Dashboard On A Raspberry Pi

Filed Under Home Automation, IOT at 7th January 2023 12:30 by

Overview I wanted to create a display of a web page on a Raspberry Pi with no desktop or browser looking controls. This is called a kiosk mode. The main driver for this is to replace the MagicMirror to show … Continue reading →

09

Dec/22

Zigbee Firmware List

Filed Under Home Automation at 9th December 2022 17:17 by

A useful list of Zigbee published firmwares are available from: OTA Image Types Firmware versions

07

Nov/22

“Real Time” Solar / Energy Dashboard

Filed Under Blog, Home Automation at 7th November 2022 0:01 by

Summary Home Assistant introduced an energy dashboard in 2021.8. Whilst useful and offers a quick setup, it lags an hour behind due to the way it presents data. So I set out to create my own “real time” dashboard. I … Continue reading →

03

Oct/22

Home Assistant With Version Control

Filed Under Home Automation, Infrastructure at 3rd October 2022 0:01 by

Overview Home Assistant works half in system (e.g. UI integrations) and half in YAML Ain’t Markup Language (YAML). YAML files are usually stored as .yml or .yaml (Home Assistant works best with the latter). More and more features are available … Continue reading →