0Home Assistant Tweaks

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

  - 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
      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.

  purge_keep_days: 42
  db_url: !secret URL_MariaDB_Thing
      - device_tracker
      - media_player
      - uptime
      - time_date
      - worldclock
      - sensor.clock*
      - sensor.date*
      - sensor.glances*
      - sensor.load_*m
      - sensor.time*
      - sensor.uptime*
      - sensor.wiser*
      - sensor.home_assistant_v2_db
      - sensor.memory_free
      - sensor.memory_use
      - sensor.memory_use_percent
      - sensor.processor_use
      - weather.openweathermap

Found this useful? Please do let us know by dropping a comment below. If you would like to subscribe please use the subscribe link on the menu at the top right. You can also share this with your friends by using the social links below. Cheers.

Leave a Reply