#7272nd of 173 in Backends, databases and hosting
timescaledb
PostgreSQL extension for time-series and event data with columnar storage
Documentation ↗
(opens in a new tab)Website ↗
(opens in a new tab)Repository on GitHub ↗
(opens in a new tab)
- Stars
- 23.9k
- License
- custom license
- Last commit
- Nov 2026
- Last release
- Nov 2026
- Language
- C
Missed the latest GitHub check; these facts may be older.
Overview
TimescaleDB adds hypertables to PostgreSQL, which partition data into time-based chunks, plus a columnstore that accepts direct inserts for analytical queries. It also provides incrementally refreshed continuous aggregates, time_bucket(), and SkipScan for DISTINCT ON queries. It is used through standard SQL and any PostgreSQL client.
Who it is for: Engineers storing metrics, IoT or event data in PostgreSQL
Strengths
- Runs inside PostgreSQL, so existing SQL, clients and extensions keep working
- Continuous aggregates refresh incrementally, unlike plain materialized views
- Columnstore compression, README cites 90%+ typical, with direct insert into columnar format
- Quickstart includes a local start script and worked examples with sample datasets
Weaknesses
- Not an AI project; it is a general time-series database extension
- License is detected as NOASSERTION; check the license terms before commercial use
- Some features, such as tiering to S3, are described under hosted Tiger Cloud
- One-line install script is for local development only, not production
What it needs
- RAM ≥ 8 GB
- no GPU
- Needs PostgreSQL, Docker (quickstart), psql
Also in Backends, databases and hosting
See all 173| Rank | Project | Score |
|---|---|---|
| 1 | bunJavaScript and TypeScript runtime with bundler, test runner and package manager | 93 out of 100 |
| 2 | traefikHTTP reverse proxy and load balancer that auto-discovers routes from orchestrators | 93 out of 100 |
| 3 | appwriteBackend with auth, databases, storage, functions and an MCP server for agents | 93 out of 100 |
| #4 | ormTypeScript ORM for PostgreSQL and MongoDB with a plugin SPI and agent skills | 93 out of 100 |
| #5 | strapiHeadless CMS that generates REST and GraphQL APIs from content models | 92 out of 100 |