XBMCNut

If you use the Home Assistant MariaDB add-on, this tip will show you how to query the database so see what Home Assistant entity states are triggering the most, filling up your database. What were going to do: Install the phMyAdmin add-on for MariaDB. Query the MariaDB database. See what entity state changes have the most action. Paste the code below into the SQL query box:  select entity_id,count( * ) from states group by entity_id order by count ( * ) desc; And if you're using the internal home-assistant_v2.db instead, you can use the SQLite Web add-on to achieve the same thing.

Get notifications and now images sent to your mobile from Home Assistant so you can keep an eye on your house. If you own a Synology NAS, this is a totally free notification option with no file limits. Awesome! No Android smart watch support for Chat just yet but hopefully that is coming soon. An example script that uses the platform is shown below - service: notify.hass_synochat data: message: "Pool Gate was opened" data: file_url: http://ipaddressofhass:8123/local/images/pool_gate.jpg N.B Ensure you turn off your phones battery optimisation feature for the Synology Chat app otherwise you won't get notifications coming through in near real time. Buy your Synology NAS here . Home Assistant Chat add-on here . Info on the Synology Chat platform is here .

Shelly have added native support for their WiFi relay switches in version 1.3 officially released this week

Got two of the Shelly2's last week and got around to a couple of overview videos today. I must say, very impressed. High quality and great GUI. Much better build than the Sonoff. Hardware overview here https://www.youtube.com/watch?v=peykCQm90-c GUI overview and API control here https://www.youtube.com/watch?v=Gok8YBQl97k Killer feature! 2-way switching https://www.youtube.com/watch?v=SVQYt5vw2k4  Shelly1 on Amazon https://amzn.to/2Qdexag Shelly2 on Amazon https://amzn.to/2Io5aSf From what I understand, more stock should be available mid Oct/18.

If you want to be able to exclusively use an external USB drive without a Micro SD  Card in a Pi3 for Hass.io , these are the steps you’ll need to make it happen. Installed Raspbian1 Lite (2017-04-10) on a MicroSD card and followed the instructions here3 to enable USB boot mode. Rebooted Pi then shut down a few minutes later. Burned hassio2 Pi3 image to a 16GB USB drive. Booted PC into Gparted1 to re-partition hassio image. Increased /dev/sdb4 from 1GB to around 4GB (must do first otherwise you can’t expand the resin-data partition). Increased /dev/sdb6 from 1GB to pretty much whatever was left. With the modified thumb drive back in my PC, I added the following located in the resin-boot drive and also in the resin-rootA partition inside the resin-boot folder : I changed the “root” option in cmdline.txt to: root=/dev/sda2 and I added the usb boot line below to config.txt , right at the end: program_usb_boot_mode=1 I then put the reworked thumb drive back in my Pi3

I made a few videos detailing my experience with Hass.io ; the all-in-one version of Home Assistant that makes it easier to update Home Assistant and install add-ons. Ben from BRUH Automation also added one today (26th July 2017) that goes into great detail and that’s at the bottom too. Enjoy.