POC is here: https://github.com/aliok/mobile-analytics-poc/ Information is here: https://github.com/aliok/mobile-analytics-poc/blob/0ba869cd1dd977db6af11cc33e68ca31d56c3b52/architecture4/README.md Summary:
- This approach is possible.
- We use TimescaleDB extension in PostgreSQL
- We push non-time series data directly into TimescaleDB (client vs sdkVersion)
- We push time series data to Prometheus and then it pushes them to TimescaleDB (sdk init events and button metrics)
- To make Prometheus work with TimescaleDB, we need to install an extension on PostgreSQL. However, Prometheus can't talk to this extension directly. There must be a separate adapter application that acts as the middle man between Prometheus and the extension on PostgreSQL.
- Grafana works well with both Prometheus and PostgreSQL.
- It is also possible to show non-time series data in Grafana.
|