TimescaleDB
also: Timescale · Tiger Data
Time-series extension for PostgreSQL that lets teams store sensor and telemetry data with ordinary SQL alongside relational product data.
TimescaleDB adds hypertables (automatically partitioned by time), compression, continuous aggregates, and retention policies to PostgreSQL, so telemetry can live next to device, customer, and product tables and be queried with standard SQL and tools. The company behind it now operates as Tiger Data.
Where it bites: some features are under a source-available license rather than Apache 2.0, performance depends on chunk sizing and indexing choices, and self-hosting versus managed service is a real operations decision.
Outside help is worth it for hypertable and schema design, compression, and retention policies, and combining telemetry with business data.
Common requests
- Schema and hypertable design
- Compression and retention policies
- Combining telemetry with product and customer data
- Migration from other time-series stores
Founder takeaway
If your team already knows PostgreSQL, TimescaleDB keeps telemetry in the same database and query language.
official site: tigerdata.com · Tiger Data (formerly Timescale)
engineer review pending