TimescaleDB
A PostgreSQL extension for time series and real-time analytics, with automatic partitioning and columnar compression. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- Tiger Data
- Created by
- Ajay Kulkarni, Mike Freedman
- First release
- 2017
- License
- Apache-2.0, Timescale License
- Open source
- Yes
- Pricing
- Free with paid plans
- Website
- https://www.tigerdata.com
- Written in
- C
- Data model
- Time-series, Relational
- Storage layout
- Hybrid row and column
- Workload
- Both (HTAP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Server, Managed cloud
- Scaling
- Replication
- Create, read, update, delete
- Create: fast (Fast appends into time-partitioned chunks); Read: fast (Columnar compression for time-range scans); Update: moderate (Slower on compressed chunks); Delete: moderate (Whole chunks dropped by retention)