Author: Bolukan

How full is the rain barrel?

I made a setup with an AJ-SR04M Waterproof Ultrasonic Sensor to measure how full the rain barrel is. The measurement data are distributed via mqtt […]

7 July 2024

Synology Calendar API v5

Synology has not yet published any documentation about the Calendar API v5. There is also little information available on forums. I have found that the […]

23 June 2024

Node-RED – one controller for all relays

I streamlined the control of actuators with a centralized controller. An abstraction layer handles diverse actuators through MQTT, while a singular controller orchestrates communication, simplifying a complex system.

8 August 2023

List of Zigbee Cluster identifiers

The cluster identifier is a 16-bit number that maps to (identifies) a single cluster specification. More than one cluster identifier may map to a cluster […]

6 August 2023

How I setup my InfluxDB

Setting up InfluxDB for home automation. Utilizing Buckets, Measurements, Fields, and Tags with MQTT, Zigbee2MQTT, OpenMQTTGateway, and Node-Red for data collection and processing.

6 August 2023

Combine Influxdb data and mysql metadata in Grafana

The solution described allows for enriching metadata in Grafana by combining data from InfluxDB with data from a MySQL database. This is achieved using Flux, the query language for InfluxDB, and the join function to merge the data based on a common attribute (topic in this case).

4 August 2023