[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)

[pushpitkamboj]

yes I saw that PR during my research
yes 2.0 is doable, built a prototype project which implements 1.7 and 2.0
Will also be adding elastic search in it. Will discuss more about this in the proposal too

[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.