Projects:Energy Data Collection Stack: Difference between revisions

From Wiki
mNo edit summary
mNo edit summary
 
(15 intermediate revisions by the same user not shown)
Line 5: Line 5:
!
!
!Open source option
!Open source option
!HA options
!Alternatives
!Alternatives
!
|-
|-
|↑
|↑
|Visualization
|Visualization
|Grafana
|Grafana
|
|
|-
|
|Reports
|Carbone? Jupyter?
|
|
|-
|
|Complex Calculations
|Jupyter
|
|
|
|
Line 17: Line 29:
|Database
|Database
|TimescaleDB
|TimescaleDB
|
|InfluxDB, Postgres
|InfluxDB, Postgres
|-
|↑
|(Kafka)
|
|
|
|
|-
|-
|↑
|↑
|MQTT to Database
|MQTT to Database
|Node-RED
|Node-RED, Benthos
|
|Telegraf
|Telegraf
|
|-
|-
|↑
|↑
|MQTT Broker
|MQTT Broker
|Mosquitto
|Mosquitto
|HAProxy, keepalived
|HiveMQ
|HiveMQ
|-
|↑
|Data Collection Equipment
|ESPHome
|
|
|
|}
|}
== Other Tools ==
* MQTT Load testing
** https://github.com/inovex/mqtt-stresser (2020, 233 *)
** https://github.com/takanorig/mqtt-bench (2015, 139*)
** https://github.com/emqx/emqtt-bench (202<nowiki/>4, 489*)
*** https://hub.docker.com/r/emqx/emqtt-bench
** https://github.com/halfgaar/MqttLoadSimulator (2024, 13*)
*MQTT to Database
** https://xaviergeerinck.com/2023/07/27/sinking-events-from-mqtt-to-timescale/
** 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 12:36, 15 April 2024

Stages

Pyramid
Open source option HA options Alternatives
Visualization Grafana
Reports Carbone? Jupyter?
Complex Calculations Jupyter
Database TimescaleDB InfluxDB, Postgres
(Kafka)
MQTT to Database Node-RED, Benthos Telegraf
MQTT Broker Mosquitto HAProxy, keepalived HiveMQ
Data Collection Equipment ESPHome

Other Tools