[GSoC] Add more timeseries database clients to OpenWISP Monitoring

[nemesifier]

Official thread for this GSoC idea, ask questions and announce your interest here.

[pushpitkamboj]

Hi I am interested for this project, already started researching on this.
I have a question. Could you share the reasoning behind choosing ElasticSearch as the additional TSDB? I reviewed the 2020 PR and related discussions, and I understand the context from that time. However, during my research I also came across TimescaleDB as a potential option worth considering. Am I missing some context that led to Elasticsearch being preferred over alternatives? (Because ElasticSearch is fundamentally a search engine, not a native TSDB)

[nemesifier]

@pushpitkamboj what do you mean with 1.7 and 2.0?

[pushpitkamboj]

sorry, i mean influxDB 1.7 and 2.0

[nemesifier]

sorry, i mean influxDB 1.7 and 2.0

Influxdb 1.8 is the version we're using now and I don't understand why you're mentioning it, can you expand?

[pushpitkamboj]

Ya sure,
I built a local machine monitoring prototype supporting InfluxDB 1.8 and 2.0 (Elasticsearch in progress), implementing the same abstraction layer as OpenWISP Monitoring like batch_write(), query(), delete_metric_data() and more. The goal was to get hands on experience with the codebase structure before writing the proposal, rather than approaching it purely theoretically.

[nemesifier]

Sounds like a good approach, if you have more questions let me know.