I’ve had a basic influxdb/grafana setup going for a year or so. Despite having worked with it for a while, I always am left with the feeling that I’m missing something.
The sql-like language is similar enough that it’s confusing. And I’m still not sure why a dedicated time series database is supposed to be better than using standard mysql/postgres with inserts. At least the you get a wider range of options for data types, indexing, and querying.
I’m likely still not in the correct mindset but not sure what I’m missing.
And I’m still not sure why a dedicated time series database is supposed to be better than using standard mysql/postgres with inserts
It's optimized for timeseries data, so queries and inserts may be faster and the storage requirements may be lower. Other than that, Postgres can probably do everything influx can do and more.
Comments
I’ve had a basic influxdb/grafana setup going for a year or so. Despite having worked with it for a while, I always am left with the feeling that I’m missing something.
The sql-like language is similar enough that it’s confusing. And I’m still not sure why a dedicated time series database is supposed to be better than using standard mysql/postgres with inserts. At least the you get a wider range of options for data types, indexing, and querying.
I’m likely still not in the correct mindset but not sure what I’m missing.
It's optimized for timeseries data, so queries and inserts may be faster and the storage requirements may be lower. Other than that, Postgres can probably do everything influx can do and more.