TiloBox
Back to directory
GitHub stars17.5k
Last commit1 weeks ago
Tags6 topics
CompressionHypertablesAnalyticsTimeseriesSqlPostgresql
Overview

Why consider TimescaleDB?

TimescaleDB is an open-source time-series SQL database built as an extension for PostgreSQL. It provides automatic chunk partitioning (hypertables), continuous aggregates, and columnar compression.

Guided learning

Learn TimescaleDB by building

Practical setup notes, real use cases, and copy-ready examples in one focused guide.

1 min read 3 sections
In this guide3 sections

Overview of TimescaleDB

TimescaleDB combines the full SQL ecosystem and relational integrity of PostgreSQL with high write throughput and analytical compression for time-series workloads.

Running with Docker

bash
1docker run -d \
2 --name timescaledb \
3 -p 5432:5432 \
4 -e POSTGRES_PASSWORD=password \
5 timescale/timescaledb:latest-pg16

Creating a Hypertable

sql
1CREATE TABLE sensor_data (
2 time TIMESTAMPTZ NOT NULL,
3 sensor_id INTEGER,
4 temperature DOUBLE PRECISION
5);
6
7SELECT create_hypertable('sensor_data', by_range('time'));

TimescaleDB is available under the Timescale License.

Related tools

More options with a similar category or technology profile.

TimescaleDB FAQs

TimescaleDB is listed as a Devops Infrastructure tool on TiloBox. Review the overview, features, and official documentation on this page to decide whether it solves your specific workflow.

Start with the project's GitHub repository and official website for supported installation and deployment instructions. Test the setup with representative data or a small project before rolling it out more widely.

TimescaleDB is listed under the Timescale-License license. Read the complete license text and the project's notices before using, modifying, or distributing the software.

Production readiness depends on your requirements. Review maintenance activity, security practices, documentation, backup and upgrade procedures, and compatibility with your stack; then validate it in a non-production environment.

TimescaleDB is listed as an alternative to ClickHouse. Compare the core workflow, deployment model, integrations, and licensing against your must-have requirements before switching.