Projects:Energy Data Collection Stack: Difference between revisions
mNo edit summary |
mNo edit summary |
||
(12 intermediate revisions by the same user not shown) | |||
Line 5: | Line 5: | ||
! | ! | ||
!Open source option | !Open source option | ||
!HA options | |||
!Alternatives | !Alternatives | ||
|- | |- | ||
Line 10: | Line 11: | ||
|Visualization | |Visualization | ||
|Grafana | |Grafana | ||
| | |||
| | | | ||
|- | |- | ||
| | | | ||
|Reports | |Reports | ||
|Carbone? Jupyter? | |||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
|Calculations | |Complex Calculations | ||
|Jupyter | |||
| | | | ||
| | | | ||
Line 25: | Line 29: | ||
|Database | |Database | ||
|TimescaleDB | |TimescaleDB | ||
| | |||
|InfluxDB, Postgres | |InfluxDB, Postgres | ||
|- | |||
|↑ | |||
|(Kafka) | |||
| | |||
| | |||
| | |||
|- | |- | ||
|↑ | |↑ | ||
|MQTT to Database | |MQTT to Database | ||
|Node-RED | |Node-RED, Benthos | ||
| | |||
|Telegraf | |Telegraf | ||
|- | |- | ||
Line 35: | Line 47: | ||
|MQTT Broker | |MQTT Broker | ||
|Mosquitto | |Mosquitto | ||
|HAProxy, keepalived | |||
|HiveMQ | |HiveMQ | ||
|- | |- | ||
|↑ | |↑ | ||
|Data Collection Equipment | |Data Collection Equipment | ||
|ESPHome | |||
| | | | ||
| | | | ||
Line 46: | Line 60: | ||
* MQTT Load testing | * MQTT Load testing | ||
** https://github.com/inovex/mqtt-stresser | ** https://github.com/inovex/mqtt-stresser (2020, 233 *) | ||
** https://github.com/takanorig/mqtt-bench<nowiki/>( | ** 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
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
- 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 (2024, 489*)
- https://github.com/halfgaar/MqttLoadSimulator (2024, 13*)
- MQTT to Database
- Reports