Migrating Home Assistant from sqlite3 to MySQL 8.0

This post quickly documents some notes around my process of migrating Home Assistant's sqlite3 database to a containerised MySQL database. I run all of my home server infrastructure in Docker containers as I like the isolation and distribution model that they provide. The default sqlite3 database used by Home Assistant…

Read this article

Making a bootable Windows 10 installer USB stick on OS X

Trying to create a Windows 10 USB stick installer using an official Microsoft ISO on Mac OS X 10.11.6 seems to be hard work. tl;dr: Using Rufus inside a Windows XP VM works I happened to have one lying around, and passing the USB stick device through…

Read this article

Initial experiments with ReSpeaker

Last year I backed a Kickstarter project called ReSpeaker, which is a (Linux-based) hardware module designed to make it as easy as possible to add speech recognition to projects. The main selling point for me is that a "far-field" microphone array is available for it, which allows far better isolation…

Read this article

Java 8 on OS X El Capitan with command-line support

Here's a quick tip if you want to install Java to be able to run Java apps from the command-line on OS X. Intuitively, installing the JRE appears to be the obvious choice, as you're not bothered about javac or other developer tools. However, the JRE DMG package doesn't register…

Read this article

Home automation with Arduino and 433Mhz plug-in receivers

I've been in the process of building a networked home automation system for my lighting (and in the future, other devices) using off-the-shelf plug-in receivers for the last year or so. I've been meaning to write a blog post about it for some time, but in the meantime, here's a…

Read this article