Home Automation System - OpenHAB 3 - 28. InfluxDB, gestione dei dati storici con RP/CQ

in Discovery-it3 years ago (edited)

domoticsduino_openhab3_influx_gestione_dati_storici.jpeg
Fonte PIXABAY - CC0 Creative Commons

Ventottesimo capitolo relativo ad OpenHAB 3.

In questo video approfondiamo il database influxdb v. 1.8, utilizzato come motore di persistenza di openhab, parlando di retention policy e di aggregazioni storiche, in ottica di ottimizzazione della quantità di dati memorizzati.

In particolare andremo a vedere come gestire la profondità storica dei dati immagazzinati andando a cancellare i dati storici oppure andandoli ad aggregare su unità di tempo maggiori per ridurne la quantità e quindi lo spazio occupato senza andare a perdere l'informazione.

Introduciamo quindi i concetti di Retention Policy e di Continuous Query, caratteristiche native dei database Influxdb che nella mia attuale installazione di openhab2 non ho mai approfondito e quindi applicato, ma in ottica di migrazione alla versione 3 volevo iniziare ad usare.

Questo video non ha la presunzione di essere un tutorial, ma semplicemente uno step by step di quanto fatto per raggiungere l'obiettivo. La speranza è che possa essere d'aiuto a qualcuno.

Buona visione

Home Automation System - OpenHAB 3 - 27. I profili, questi sconosciuti: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-121ebc0d8f68d
Home Automation System - OpenHAB 3 - 26. Integrazione con Amazon Alexa
: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-1ed92c6a87e3d
Home Automation System - OpenHAB 3 - 25. Integrazione con Google Home Parte 2: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-70f51533ee485
Home Automation System - OpenHAB 3 - 25. Integrazione con Google Home Parte 1: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-ab69b2c165917
Home Automation System - OpenHAB 3 - 24. GPIO Binding - Esempio INPUT/OUTPUT con Rules: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-93f5877a98612
Home Automation System - OpenHAB 3 - 23. GPIO Binding - Esempio INPUT: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-0fac507adc5a3
Home Automation System - OpenHAB 3 - 22. GPIO Binding - Esempio OUTPUT: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-d4a61d72e3efe
Home Automation System - OpenHAB 3 - 21. GPIO Binding: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-4f65ed1d683b5
Home Automation System - OpenHAB 3 - 20. MQTT Payload Custom con trasformazioni: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-79ebba3492503
Home Automation System - OpenHAB 3 - 19. HTTP Binding: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-941a676ffc361
Home Automation System - OpenHAB 3 - 18. Notifiche PUSH tramite API: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-376d791360bb3
Home Automation System - OpenHAB 3 - 17. Esempi di utilizzo delle API: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-ac1f3a28db3b4
Home Automation System - OpenHAB 3 - 16. API for Dummies: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-e79600902c98e
Home Automation System - OpenHAB 3 - 15. Automatizziamo con le rules Parte 1: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-6b9d4bbd62098
Home Automation System - OpenHAB 3 - 14. Montaggio Kit Bruphny per RPI 4: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-15004dba05a43
Home Automation System - OpenHAB 3 - 13. SONOFF POW - Semplice misuratore di consumi: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-497b37d461a4e
Home Automation System - OpenHAB 3 - 12. MQTT for Dummies: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3
Home Automation System - OpenHAB v. 3 - 11. Mosquitto Broker MQTT con Docker: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-231fb1e8c1ed7
Home Automation System - OpenHAB v. 3 - 10. Floorplan interattivi: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-8a49b5f73d857
Home Automation System - OpenHAB v. 3 - 09. Modellazione Semantica Parte 2: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-095db637ae3fd
Home Automation System - OpenHAB v. 3 - 09. Modellazione Semantica Parte 1: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-d8ea3d8869e52
Home Automation System - OpenHAB v. 3 - 08. OpenHAB Remote Binding: istanze multiple connesse: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-32f99157d0ea1
Home Automation System - OpenHAB v. 3 - 07. Migrazione database InfluxDB: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-4b6a97a638e4
Home Automation System - OpenHAB v. 3 - 06. Dashboard con Grafana e InfluxDB: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-515cb6b3997e2
Home Automation System - OpenHAB v. 3 - 05. Persistenza con InfluxDB: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v
Home Automation System - OpenHAB v. 3 - 04. InfluxDB-Docker Get Started: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-3-04-influxdb-docker-get-started
Home Automation System - OpenHAB v. 3 - 03. Sitemap: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-3-03-sitemap
Home Automation System - OpenHAB v. 3 - 02. MQTT Test Parte 2: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-3-02-mqtt-test-parte-2
Home Automation System - OpenHAB v. 3 - 02. MQTT Test Parte 1 https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-3-02-mqtt-test-parte-1
Home Automation System - OpenHAB v. 3 - 01. Installazione https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-v-3-01-installazione

Video di mia proprietà

Sort:  

!discovery 30


This post was shared and voted inside the discord by the curators team of discovery-it
Join our community! hive-193212
Discovery-it is also a Witness, vote for us here
Delegate to us for passive income. Check our 80% fee-back Program