Projects:Energy Data Collection Stack: Difference between revisions
mNo edit summary |
mNo edit summary |
||
(6 intermediate revisions by the same user not shown) | |||
Line 7: | Line 7: | ||
!HA options | !HA options | ||
!Alternatives | !Alternatives | ||
|- | |- | ||
|↑ | |↑ | ||
|Visualization | |Visualization | ||
|Grafana | |Grafana | ||
| | | | ||
| | | | ||
Line 18: | Line 16: | ||
| | | | ||
|Reports | |Reports | ||
| | |Carbone? Jupyter? | ||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
|Calculations | |Complex Calculations | ||
| | |Jupyter | ||
| | | | ||
| | | | ||
Line 35: | Line 31: | ||
| | | | ||
|InfluxDB, Postgres | |InfluxDB, Postgres | ||
|- | |- | ||
|↑ | |↑ | ||
|(Kafka) | |(Kafka) | ||
| | | | ||
| | | | ||
Line 46: | Line 40: | ||
|↑ | |↑ | ||
|MQTT to Database | |MQTT to Database | ||
|Node-RED | |Node-RED, Benthos | ||
| | | | ||
|Telegraf | |Telegraf | ||
|- | |- | ||
|↑ | |↑ | ||
Line 56: | Line 49: | ||
|HAProxy, keepalived | |HAProxy, keepalived | ||
|HiveMQ | |HiveMQ | ||
|- | |- | ||
|↑ | |↑ | ||
|Data Collection Equipment | |Data Collection Equipment | ||
| | |ESPHome | ||
| | | | ||
| | | | ||
Line 77: | Line 68: | ||
** 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 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