TimescaleDB
More info
- Creator
- Mike Freedman, Ajay Kulkarni
- Released
- Owner
- Timescale Inc.
- Type
- Time-series DB (Postgres extension)
- License
- Apache 2.0 + Timescale License
- Website
- timescale.com
- Source
- github.com/timescale/timescaledb
- Wikipedia
- en.wikipedia.org
Postgres extension that adds time-series superpowers — automatically partitioned "hypertables", continuous aggregates, compression and retention policies.
Founded in 2017. Hypertables: look like a regular table but under the hood are partitioned by time and optionally by device. Continuous aggregates: materialised views that update incrementally. Columnar compression can shrink data 10–20×.
Advantage over InfluxDB: you have full SQL, JOINs, foreign keys, the whole Postgres ecosystem. Competitors: InfluxDB, QuestDB, Prometheus, VictoriaMetrics. Sweet spot: when time series is part of a broader app, not a separate system.