We're looking at adding an analytics product and need to use a time series database. After initial research, it seemed like InfluxDB was the way to go.<p>But we ran into an issue - which version do we use? It seems like they're pushing V3 but we've struggled to get the Node client to query data (writes seem to work). Anyone have experience with this?
(:alert: I work for Timescale :alert:)<p>It's funny, we hear this more and more "we did some research and landed on Influx and ... help it's confusing".<p>We actually wrote an article about what we think, you can find it here: <a href="https://www.timescale.com/blog/what-influxdb-got-wrong/" rel="nofollow noreferrer">https://www.timescale.com/blog/what-influxdb-got-wrong/</a><p>As the QuestDB folks mentioned if you want a drop in replacement for Influx then they would be an option, it kinda sounds that's not what you want though - why buy into an ecosystem which isn't a good fit for you?<p>If you want something based on PostgreSQL, rock-solid, supports full SQL, and gives you all the benefits of a relational database, combined with all the functionality of a time-series database then give <a href="https://docs.timescale.com" rel="nofollow noreferrer">https://docs.timescale.com</a> a look.<p>We have a cloud product at <a href="https://timescale.com" rel="nofollow noreferrer">https://timescale.com</a> if you're into that.
Update: Have been digging into this more and it looks like we're going to switch to QuestDB.<p>Seems like a solid bet with clear roadmap, pricing and strong performance. Also, looks to be more affordable than Timescale.<p>InfluxDB was such a bait though - it has potential but unfortunately, don't want to take that risk with our infrastructure.<p>Thanks for the answers below - was really helpful in making a decision.
I agree that the difference in versions is confusing!<p>If InfluxDB is not the right fit, QuestDB can be a good drop-in replacement as it uses a high-performance implementation of the InfluxDB Line Protocol for ingesting data and SQL for queries. There are several SQL extensions for time-series data to simplify queries, such as SAMPLE BY (downsampling), WHERE ... IN (time intervals), LATEST ON (latest records) and ASOF JOIN (time-series joins).<p>An intro about QuestDB can be found here: <a href="https://questdb.io/docs/">https://questdb.io/docs/</a>
And a live demo with three datasets (one of them has got data being streamed live): <a href="https://demo.questdb.io/">https://demo.questdb.io/</a><p>Another well-known time-series database includes TimescaleDB, an extension built on top of Postgres.<p>I should disclose that I'm a co-founder of QuestDB.
What are your requirements? We see some people switching from InfluxDB to QuestDB. Common reasons include SQL support (InfluxDB strategy is a bit confusing here), performance and issues with high-cardinality in InfluxDB.<p>Full Disclosure: I work for QuestDB and I am obviously biased.