neilh10
commented
1 year ago https://github.com/ODM2/ODM2DataSharingPortal/issues/334 https://github.com/ODM2/ODM2DataSharingPortal/blob/main/doc/ArchitectureDiagram/Data%20Sharing%20Portal%20Architecture%20with%20Logos%20-%20Copy.png https://github.com/ODM2/ODM2DataSharingPortal/milestone/25 https://github.com/ODM2/ODM2DataSharingPortal/milestone/24
ODM2 issue 502 and 665 stated that what is in use is PosgreSQL Timescale extension (i.e. TimescaleDB) with our v0.12 release in December 2021.
Update ODM2 description to be tracked in ODM2 697
Try an adventurous prototype for MQTT Level1 to timescaledb with some possible custom visualization in Grafana Target reduce power, by reducing size of messages and how security works.
https://www.timescale.com/community MQTT https://www.timescale.com/blog/how-i-am-planning-my-photovoltaic-system-using-timescaledb-nodered-and-grafana/
see internal description ModularSensors-diary "Data Ingestion ~ MQTT to timescaledb" https://www.envirodiy.org/internet-of-water-gave-rise-to-state-of-the-science-sensor-data-sharing/ says using timescaleDB https://www.timescale.com/
Roberto: TBMQ from ThingsBoard that is MQTT but open source and thoroughly tested by them, https://github.com/thingsboard/tbmq https://thingsboard.io/docs/mqtt-broker/reference/3m-throughput-single-node-performance-test/
M.I.N.G. stack you can start here; https://blog.balena.io/ming-stack-mqtt-influxdb-nodered-grafana-balena/
https://www.emqx.com/en/blog/how-to-use-mqtt-in-vue Vue Framework