Search code examples
databasetime-seriesinfluxdbprometheusgraphite

Which time series database to use for persistent and accurate historical data


We need to store and read exact counter data (integers) over many years basically just with time filtering. Historical imports into the database will be necessary as well and the data is available in fixed time windows (every minute / hour).

It seems that Prometheus, for instance, is not a good fit because they don't ensure 100% accuracy. There are so many listings and comparisons but this is often not even mentioned although it is definitely an important detail.

So the question is: which modern database would be a good fit for such data?

The amount of possible TS databases seems to be endless. Would one or more of InfluxDB, Druid, Riak TS, graphite, OpenTSDB or timely be suitable? Or maybe some other candidate?


Solution

  • It looks like you need some ACID-compliant database. For example TimescaleDB.