I’ve made a number of improvements to my home assistant instance of late and wanted to document what they were
Add ZigBee to sidebar menu
I have a ConBee ZigBee USB stick but to view the network I’ve always had to go in via configuration -> integrations. I wanted instead to have a direct link on the main left-hand menu. An article on DigiBlur had most of the info I needed. I adjusted the 1 line needed, restarted HA and got the desired menu straight away. Just add the following code to you configuration.yaml
panel_custom: - name: ha_zha_con sidebar_title: ZigBee sidebar_icon: mdi:cog-transfer js_url: /api/hassio/app/entrypoint.js url_path: 'config/zha/visualization' embed_iframe: true require_admin: true config: ingress: core_configurator
Switch database to mariadb
This only switches the history database and has no risk of breaking your HA setup. You may well lose your history though — I wanted to get rid of my 4Gig database so I choose to delete it before restarting so I could start from clean. I followed a nice guide by lkeays on the HA forums. I also wanted to make sure the database didn’t expand out of control again in future so I also tweaked what is kept in the database by following a guide by denilsonsa also on the HA forums. I ended up adding the following to configuration.yaml (note you do also need to add a couple of addons via the supervisor add-on store so do read the guides linked as you need more than just the code below.
recorder: purge_keep_days: 42 db_url: !secret URL_MariaDB_Thing exclude: domains: - device_tracker - media_player - uptime - time_date - worldclock entity_globs: - sensor.clock* - sensor.date* - sensor.glances* - sensor.load_*m - sensor.time* - sensor.uptime* - sensor.wiser* entities: - sensor.home_assistant_v2_db - sensor.memory_free - sensor.memory_use - sensor.memory_use_percent - sensor.processor_use - weather.openweathermap
“Hi James I realise it has been a long while, but I just checked this on windows 11 (build 23H2)…”