MariaDB container setup
Setting up the MariaDB container with Linux or NixOS configuration.
Databases
12 posts with the tag “Databases”
How to save P1 reader data with Smartmeter2mqtt and n8n to QuestDB
Creating an n8n flow to receive parsed P1 reader data from Smartmeter2mqtt and save it to QuestDB, which can then be used as a data source for tools like Grafana or Budibase.
n8n container setup
n8n is a workflow automation platform enabling you to connect anything to everything.
QuestDB container setup
QuestDB is a high-performance, open-source time series database and a compelling alternative to InfluxDB.
InfluxDB 2.x container setup
Setting up the InfluxDB time series database container.
Telegraf container with InfluxDB to monitor Docker setup
Setting up Telegraf to monitor Docker so Home Assistant can use this data.
How to access the InfluxDB API using the Node-RED request node
Using the Node-RED request node to access the InfluxDB API.
How to delete a measurement from InfluxDB 2.x
Deleting InfluxDB 2.x measurements by API or shell command.
Home Assistant container setup with MariaDB and InfluxDB 2.x
Setting up the Home Assistant container with MariaDB for the recorder and InfluxDB 2.x for the history.
How to add InfluxDB 2.x database size sensor to Home Assistant
Adding a sensor to Home Assistent to monitor the size of the InfluxDB 2.x database with a scan interval of one hour.
How to add MariaDB database size sensor to Home Assistant
Adding a sensor to Home Assistent to monitor the size of the MariaDB database with a scan interval of one hour.
How to backup MariaDB databases daily with crontab
Using mysqldump and the crontab to backup MariaDB databases.