Here I describe how to create a n8n flow that receives parsed P1 reader data from Smartmeter2mqtt and then how to save this data to QuestDB with n8n. [ Read More]

As a big fan of Node-RED and Apache Hop, it took me a long time to give n8n a try. But because n8n is one of the few that has out-of-the-box nodes for QuestDB and because I wanted to [[P1 reader - Save Data From Smartmeter2mqtt with n8n to QuestDB|store]]... [ Read More]

QuestDB is a high-performance, open-source SQL database. QuestDB’s stack is engineered from scratch, zero-GC Java and dependency-free. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports. [ Read More]

InfluxDB is a time series database. [ Read More]

Here I describe my setup of the Docker Telegraf container. Telegraf from InfluxData is a server agent for collecting metrics from sensors and systems [ Read More]

Within Node-RED you can use the InfluxDB nodes. But it is also possible to query the InfluxDB v2 API via the HTTP Request node. This note contains a brief description of how this works. [ Read More]

I regularly delete a ‘sandbox’ measurement with test data. It is not very complicated to delete a measurement, but it is worth noting. [ Read More]

Here I describe how to create a sensor for Home Assistant that will monitor the size of the MariaDB database with a scan interval of one hour. [ Read More]

Here I describe how to create a sensor for Home Assistant that will monitor the size of the InfluxDB 2.x database with a scan interval of one hour. [ Read More]

Here I describe my setup of the Home Assistant container with MariaDB and InfluxDB 2.x. [ Read More]