Projects:Energy Data Collection Stack: Difference between revisions

From Wiki
mNo edit summary
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
Line 5: Line 5:
!
!
!Open source option
!Open source option
!HA options
!Alternatives
!Alternatives
|-
|-
Line 11: Line 10:
|Visualization
|Visualization
|Grafana
|Grafana
|
|
|
|-
|-
|
|
|Reports
|Reports
|Carbone?
|Carbone? Jupyter?
|
|
|
|-
|-
Line 23: Line 20:
|Complex Calculations
|Complex Calculations
|Jupyter
|Jupyter
|
|
|
|-
|-
Line 29: Line 25:
|Database
|Database
|TimescaleDB
|TimescaleDB
|
|InfluxDB, Postgres
|InfluxDB, Postgres
|-
|-
|↑
|↑
|(Kafka)
|Kafka to database
|
|Debezium, Benthos, Node-RED
|
|
|
|-
|-
|↑
|↑
|MQTT to Database
|MQTT to Kafka
|Node-RED
|Benthos, Node-RED
|
|Telegraf
|Telegraf
|-
|-
Line 47: Line 40:
|MQTT Broker
|MQTT Broker
|Mosquitto
|Mosquitto
|HAProxy, keepalived
|HiveMQ, EMQX
|HiveMQ
|-
|-
|↑
|↑
|Data Collection Equipment
|Data Collection Equipment
|
|ESPHome
|
|
|
|}
|}
Line 68: Line 59:
** https://xaviergeerinck.com/2023/07/27/sinking-events-from-mqtt-to-timescale/
** https://xaviergeerinck.com/2023/07/27/sinking-events-from-mqtt-to-timescale/
** https://github.com/tobymurray/mqtt-to-timescaledb
** https://github.com/tobymurray/mqtt-to-timescaledb
*Reports
**https://www.reddit.com/r/Jupyter/comments/qk5zee/using_jupyter_as_a_document_pdf_generator/
[[Category:Projects]]
[[Category:Projects]]

Latest revision as of 15:22, 19 October 2024

Stages

Pyramid
Open source option Alternatives
↑ Visualization Grafana
Reports Carbone? Jupyter?
Complex Calculations Jupyter
↑ Database TimescaleDB InfluxDB, Postgres
↑ Kafka to database Debezium, Benthos, Node-RED
↑ MQTT to Kafka Benthos, Node-RED Telegraf
↑ MQTT Broker Mosquitto HiveMQ, EMQX
↑ Data Collection Equipment ESPHome

Other Tools

Retrieved from "https://wiki.marcluerssen.de/index.php?title=Projects:Energy_Data_Collection_Stack&oldid=4233"