Projects:Energy Data Collection Stack: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (7 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 69: | 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 | ** https://github.com/takanorig/mqtt-bench (2015, 139*) | ||
** https://github.com/emqx/emqtt-bench | ** https://github.com/emqx/emqtt-bench (202<nowiki/>4, 489*) | ||
*** https://hub.docker.com/r/emqx/emqtt-bench | *** https://hub.docker.com/r/emqx/emqtt-bench | ||
**https://github.com/halfgaar/MqttLoadSimulator | ** https://github.com/halfgaar/MqttLoadSimulator (2024, 13*) | ||
*MQTT to Database | *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