TimescaleDB

TimescaleDB is a PostgreSQL extension for time-series and real-time analytics. It adds hypertables that partition data by time automatically and a columnstore for fast analytical queries, while you keep using standard SQL, Postgres tools and the Postgres ecosystem. It is developed by Tiger Data, formerly Timescale.

TimescaleDB lets you write data straight into a compressed columnstore and run analytical queries on it alongside regular Postgres tables. It runs anywhere Postgres does, from a one-line local install or Docker image to production deployments, and works with psql, pgAdmin and other Postgres clients.

TimescaleDB lets teams that already run Postgres handle time-series and analytics workloads without adding a separate database. Part of it is under a source-available license, explained below.

TimescaleDB is split across two licenses. Most of the code is Apache 2.0. The advanced features in the "tsl" folder, including compression and the columnstore, are under the Timescale License: you can use them free of charge, including inside your own products and services, but you can't offer TimescaleDB to others as a database-as-a-service. Because of that part it isn't fully open source.

Stars

0

Forks

0

Commits

0

Repository

timescale/timescaledb

• InfluxDBNo. 139Time-series database with open-source and commercial editions.
• Amazon TimestreamAWS's managed time-series database.
• SSnowflakeHosted cloud data warehouse.
• QuestDBNo. 301Open-source time-series database with SQL.

See every open-source alternative to Amazon Timestream in the collection.