TimescaleDb
Open-source time-series database with automatic partitioning, columnar compression, and 200+ SQL functions. Fully PostgreSQL compatible for real-time analytics at scale.
TimescaleDb is an open-source alternative to:
TimescaleDB
TimescaleDB is an open-source time-series database built on PostgreSQL, designed for high-performance real-time analytics on time-series data. It combines the reliability of PostgreSQL with specialized time-series optimizations, making it ideal for applications requiring fast ingest, efficient storage, and complex queries.
Key Features
- 100% PostgreSQL Compatible: Runs as a PostgreSQL extension, leveraging existing PostgreSQL tools, drivers, and ecosystem.
- Automatic Partitioning: Hypertables automatically partition data by time or ID for fast ingest and predictable queries with partition skipping.
- Hybrid Row/Columnar Storage: Recent data stays in row format for writes, while older data converts to columnar for fast analytical scans.
- Up to 95% Compression: Reduces storage costs significantly while keeping years of history queryable online using delta, dictionary, and RLE encodings.
- 200+ Native SQL Functions: Hyperfunctions simplify advanced time-series analysis with functions for time-weighted averages, interpolation, and partial aggregations.
- Incremental Materialized Views: Continuous aggregates refresh rollups incrementally, keeping dashboards instant with parallelized batched refreshes.
- Automated Management: Built-in job scheduler with retries, configurable retention policies, and full auditability for columnstore, retention, and aggregate refresh.
- Real-time Analytics: Queryable real-time analytics at production scale with compressed history.
Tech / Self-Hosting
- Open Source: Available under the Apache 2.0 license with 23,000+ GitHub stars.
- Self-Hosted Options: Deployable on-premises, in private clouds, or via cloud platforms like Tiger Cloud.
- Enterprise Features: TimescaleDB Enterprise offers additional capabilities for on-prem, edge, and private cloud deployments.
- Cloud Platform: Tiger Cloud provides a robust elastic cloud platform for startups and enterprises.
- Documentation: Comprehensive docs available at https://www.tigerdata.com/docs.