Establish timeseries database for Flotilla

[aeshub]

Describe the new feature you would like to see
The Flotilla system will have access to timeseries streamed from the MQTT broker which should be stored in a timeseries database. Examples are mission status, battery level, pose etc.

Describe the solution you'd like
The MQTT broker established as part of #47 should stream all relevant topics to the database where it is stored in a functional format. An example of a timeseries database is InfluxDB which is available in Azure.

EDIT by Torstein:

While looking into this, I think that PostreSQL and timescale db is a good option for us.
By using that we can link the timeseries relationally to the rest of our database.

https://azure.microsoft.com/nb-no/blog/power-iot-and-time-series-workloads-with-timescaledb-for-azure-database-for-postgresql/
https://docs.timescale.com/getting-started/latest/

How will this feature affect the current Threat Model?
Access to the timeseries database must be managed.

• Note that the first iteration will only be a database available locally on the facility tightly coupled with Flotilla.

[aeshub]

[aeshub]

This issue has automatically been marked as stale as there has been no activity for 60 days. Remove stale label or comment or this will be closed in 7 days.

[aeshub]

Alternatives mentioned have also been IOTHUB, MQTT + SparkPlug

[aeshub]

This issue has automatically been marked as stale as there has been no activity for 60 days. Remove stale label or comment or this will be closed in 7 days.

[GodVenn]

While looking into this, I think that PostreSQL and timescale db is a good option for us.
By using that we can link the timeseries relationally to the rest of our database.

https://azure.microsoft.com/nb-no/blog/power-iot-and-time-series-workloads-with-timescaledb-for-azure-database-for-postgresql/
https://docs.timescale.com/getting-started/latest/

[aeshub]

This issue has automatically been marked as stale as there has been no activity for 60 days.

[aeshub]

This issue has automatically been marked as stale as there has been no activity for 60 days.