Home Assistant & whole-home power monitoring

Home Assistant & whole-home power monitoring

I recently purchased an Eastron SDM630 power meter and a Modbus TCP Gateway. This is a smart meter, which is installed behind my power company’s meter (since this can’t be changed or touched).  The meter itself is about 130€ and can be found on Amazon. I opted for the Ebay one linked above, since it… Continue Reading Home Assistant & whole-home power monitoring

Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 3

Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 3

This is the third part in my series of scraping data from the local police department, to gather crime statistics over time. Part 1 covers the collection of the images Part 2 covers the finding of the pins on the image Part 3 (This part) will cover determining where the pins are geographically located Part… Continue Reading Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 3

Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 2

Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 2

This is part two in my quest to determine the long-term crime statistics, in the city where I intend to buy a house. Click here for part one, where I collect the images weekly from the police’s site. In this step, I’ll pick the images out of the S3 bucket, and attempt to find all the… Continue Reading Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 2

Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 1

Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 1

I want to buy a house in a nice neighbourhood. My local police department provides statistics, but they only offer a static image with the weekly break-ins superimposed on a map. I contacted them to see if they could provide the raw data used to produce their map. They said that this is not something… Continue Reading Using Python, OpenCV and AWS Lambda to gather crime statistics – Part 1

Home Automation Smart Node

Home Automation Smart Node

A central actor in my home automation system is a Smart Node. These small nodes can: Detect motion Sense temperature & humidity Indicate status with an RGB LED IR Receiver (not yet implemented in software) Parts List To build the Smart Node, you will need the following Wemos D1 Mini, or NodeMCU (Any ESP8266-based breakout… Continue Reading Home Automation Smart Node

Faking Syslog Messages

Faking Syslog Messages

A few years ago I wrote a handy little tool to solve a simple problem: test automated ticketing & alerting based on syslog messages. The problem was presented to me while working for a large telecommunications provider who had outsourced their fault monitoring to an off-shore consulting company. This particular company had a habit of… Continue Reading Faking Syslog Messages

Starving in the Voodoo Restaurant

Starving in the Voodoo Restaurant

The story below about VoodooFood Restaurant is modelled after a firewall rule implementation procedure. All names, characters, processes and incidents portrayed in this story are fictitious. No identification with actual telecom providers or other large businesses is intended or should be inferred. Hi, Welcome to voodoo food restaurant what can I get for you? I… Continue Reading Starving in the Voodoo Restaurant

Home Assistant migration from Sqlite3 to MariaDB (MySQL)

Home Assistant migration from Sqlite3 to MariaDB (MySQL)

I setup home assistant around six months ago, and I have amassed a sqlite database around 700Mb. Today, the entire six months of history is in the Sqlite database which is causing home assistant to hang for minutes when I try to look at history, even if the requested history is only today. For other stuff,… Continue Reading Home Assistant migration from Sqlite3 to MariaDB (MySQL)

Building WhaleSay with Docker and Gitlab-CI

Building WhaleSay with Docker and Gitlab-CI

This describes from start to finish how to configure Gitlab’s continuous integration to build a docker image. I couldn’t find any simple documentation on what all needs to be setup to build a docker image, so I hope someone finds this useful. I run a rancher cluster, and all my services run on top of this cluster… Continue Reading Building WhaleSay with Docker and Gitlab-CI