Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing InfluxDB vs Timescaledb, the Slant community recommends Timescaledb for most people. In the question“What are the best time-series databases and/or data stores?” Timescaledb is ranked 1st while InfluxDB is ranked 3rd. The most important reason people chose Timescaledb is:
Implemented as a PostgreSQL extension, not a fork.
Question Ranking
Pros
Pro Easy visualization and monitoring
Can be easily visualized with Chronograf or Graphana.
Pro Open source
InfluxDB is licensed under the MIT license with source code available on GitHub.
Pro Many official drivers
Drivers written in C#, Go, Java, PHP, Python, Rails, and Ruby are available with many more community written drivers.
Pro Powerful data query & manipulation language: FLUX
FLUX is InfluxDB's new query & manipulation language. It's not at all like SQL (unlike the previous query language) - but is more powerful, testable & development friendly
Pro Pluggable storage model
Pro Powered by PostgreSQL
Implemented as a PostgreSQL extension, not a fork.
Pro Reliable at its core
Based on PostgreSQL hence inherits PostgreSQL’s operational maturity.
Pro Highly available
Support for streaming data replication and robust backup / recovery.
Pro Enterprise-grade security
Fine-grained access control, LDAP support, encryption, and flexible authentication built-in.
Pro Handle high query traffic
Deploy read replicas for higher query throughput.
Pro Data lifecycle management
Support for efficient data retention and archiving.
Pro Data model freedom
Store schemas or go schema-less with JSON. Use narrow or wide tables. Stop worrying about high cardinality.
Pro Geospatial queries
Grow your use case with PostGIS.
Cons
Con Loses data when overloaded
Con Poor performance for deletion with predicates
Con Clustering not available with the free version
Unfortunately, clustering is not available with the free version (source).
Con Uses a lot of RAM
Con No same-time insert
No duplicate times.
