Month: May 2018

Using LetsEncrypt with Ubiquiti Unifi Video server

I’ve spent a lot of time scratching my head trying to get LetsEncrypt, or more accurately certbot working with Ubiquiti UniFi Video server, especially auto-renewing the certificate every month or so. I found two posts on the Ubiquiti…

Read More »

SQL Tips – List of Countries (2018 revision)

Over nine years ago, I published a SQL and tab delimited list of countries sourced from Wikipedia and ISO. After numerous comments about it being out of date, here is an updated version….. The data was sourced from…

Read More »