I have a very general high level design question I want your advice on.
Let’s consider a stock trading dashboard application frontend, which has to:
- allow the user to query the price for a particular stock in a time range in the past
- real-time updates for prices of selected securities.
I have two design alternatives I am considering:
- Grafana cloud (Mimir for long term storage)
- Clickhouse.
The Clickhouse stack currently presents many advantages such as easily exporting the data to numpy for easy computations of indicators etc. on the backend.
Are there advantages with the Grafana stack at all that I should consider?