Ask HN: Best database to store time series for analysis?
As the title says, which is the best database as a basis for a time series analysis system and why would you recommend it?
Also do you need a custom datapoint schema?
Do you need a generic tags/labels/dimensions?
Do you need flexible datatypes, or numeric/float only?
Do you need roll-ups, aggregations, window functions, stream processing, etc.
Probably any SQL database will do the job, but I felt there was probably a more domain-specific solution maybe with a good pandas integration? I don’t really want to write my own SQL code and think much about schemas.
But for your usecase I think TimescaleDB will be the best fit. It's an opensource extension for PostgreSQL, so you can use any PL/framework which can work with Postgres. And you have all the felxibility of RDBMS and can use standard SQL queries.
[1] https://en.wikipedia.org/wiki/Kdb%2B https://code.kx.com/q/
Do you have any experience with QuestDB?