Home Automation System - OpenHAB 3 - 29. InfluxDB metadata - nomi tabelle e attributi

in Discovery-it2 months ago

domoticsduino_openhab3_influx_metadata_nomi_tabelle_attributi_01.jpeg
Fonte PIXABAY - CC0 Creative Commons

Ventinovesimo capitolo relativo ad OpenHAB 3.

In questo video continuiamo il piccolo approfondimento su influxdb usato come motore di persistenza di openhab3 e andiamo a vedere come personalizzare il nome delle tabelle di destinazione dei dati dei singoli item per poterli aggregare nella stessa tabella.

Infatti di default openhab scrive i dati di ogni item in tabelle differenti, chiamate con il nome dell'item stesso. Per chi ha tanti item questo porta a un proliferarsi di tabelle, rendendo la gestione dell'intero database un pò disordinata...Utilizzando i metadata di openhab3 è possibile decidere di scrivere i dati degli item in una ben precisa tabella che può quindi ricevere dati da item diversi.

Ad esempio se in casa avessimo 10 sensori di temperatura, ognuno gestito ovviamente da un item diverso, nella situazione di default avremmo su influxdb 10 tabelle...utilizzando i metadata invece potremmo creare una sola tabella ed inserire i dati dei 10 sensori al suo interno, ovviamente caratterizzandoli da indici (chiamati tag) per poterne identificare la provenienza.
Questo rende sicuramente più leggibile il database e soprattutto rende più facile il reperimento delle informazioni.

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 - 28. InfluxDB, gestione dei dati storici con RP/CQ: https://hive.blog/hive-193212/@marcolino76/home-automation-system-openhab-3-1fe05af9f79e5
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

Congratulations @marcolino76! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 71000 upvotes.
Your next target is to reach 72000 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out the last post from @hivebuzz:

Feedback from the April 1st Hive Power Up Day
Hive Power Up Day - April 1st 2021 - Hive Power Delegation