TimescaleDB logo

TimescaleDB

Scalable and reliable time-series SQL database optimized for fast ingest and complex queries. Built on PostgreSQL.
53
57
+ 1
17

What is TimescaleDB?

TimescaleDB: An open-source database built for analyzing time-series data with the power and convenience of SQL — on premise, at the edge, or in the cloud.
TimescaleDB is a tool in the Databases category of a tech stack.
TimescaleDB is an open source tool with 7.9K GitHub stars and 426 GitHub forks. Here’s a link to TimescaleDB's open source repository on GitHub

Who uses TimescaleDB?

Companies
24 companies reportedly use TimescaleDB in their tech stacks, including ScreenAware, WakaTime, and LaunchDarkly.

Developers
26 developers on StackShare have stated that they use TimescaleDB.

TimescaleDB Integrations

Python, PostgreSQL, Ruby, Kubernetes, and Django are some of the popular tools that integrate with TimescaleDB. Here's a list of all 33 tools that integrate with TimescaleDB.

Why developers like TimescaleDB?

Here’s a list of reasons why companies and developers use TimescaleDB
TimescaleDB Reviews

Here are some stack decisions, common use cases and reviews by companies and developers who chose TimescaleDB in their tech stack.

John Kodumal
John Kodumal
CTO at LaunchDarkly · | 15 upvotes · 188.9K views
atLaunchDarklyLaunchDarkly
Amazon RDS
Amazon RDS
PostgreSQL
PostgreSQL
TimescaleDB
TimescaleDB
Patroni
Patroni
Consul
Consul
Amazon ElastiCache
Amazon ElastiCache
Amazon EC2
Amazon EC2
Redis
Redis
Amazon Kinesis
Amazon Kinesis
Kafka
Kafka

As we've evolved or added additional infrastructure to our stack, we've biased towards managed services. Most new backing stores are Amazon RDS instances now. We do use self-managed PostgreSQL with TimescaleDB for time-series data—this is made HA with the use of Patroni and Consul.

We also use managed Amazon ElastiCache instances instead of spinning up Amazon EC2 instances to run Redis workloads, as well as shifting to Amazon Kinesis instead of Kafka.

See more
Mauro Bennici
Mauro Bennici
CTO at You Are My GUide · | 7 upvotes · 12.4K views
atYou Are My GUideYou Are My GUide
PostgreSQL
PostgreSQL
TimescaleDB
TimescaleDB
MongoDB
MongoDB

PostgreSQL plus TimescaleDB allow us to concentrate the business effort on how to analyze valuable data instead of manage them on IT side. We are now able to ingest thousand of social shares "managed" data without compromise the scalability of the system or the time query. TimescaleDB is transparent to PostgreSQL , so we continue to use the same SQL syntax without any changes. At the same time, because we need to manage few document objects we dismissed the MongoDB cluster.

See more
SciFin Technologies
SciFin Technologies
Quantitative Developer at SciFin Technologies · | 1 upvotes · 8.5K views
atSciFin TechnologiesSciFin Technologies
Python
Python
Sanic
Sanic
PostgreSQL
PostgreSQL
TimescaleDB
TimescaleDB
Redis
Redis

Python Sanic PostgreSQL TimescaleDB Redis

Simple, yet, astonishingly fast and powerful stack to handle huge load of data feed from cryptocurrency exchanges across the globe.

See more

TimescaleDB's Features

  • Packaged as a PostgreSQL extension
  • Full ANSI SQL
  • JOINs (e.g., across PostgreSQL tables)
  • Complex queries
  • Secondary indexes
  • Composite indexes
  • Support for very high cardinality data
  • Triggers
  • Constraints
  • UPSERTS
  • JSON/JSONB
  • Ability to ingest out of order data
  • Ability to perform accurate rollups
  • Data retention policies
  • Fast deletes
  • Integration with PostGIS and the rest of the PostgreSQL ecosystem

TimescaleDB Alternatives & Comparisons

What are some alternatives to TimescaleDB?
InfluxDB
InfluxDB is a scalable datastore for metrics, events, and real-time analytics. It has a built-in HTTP API so you don't have to write any server side code to get up and running. InfluxDB is designed to be scalable, simple to install and manage, and fast to get data in and out.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
Citus
It's an extension to Postgres that distributes data and queries in a cluster of multiple machines. Its query engine parallelizes incoming SQL queries across these servers to enable human real-time (less than a second) responses on large datasets.
Druid
Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
PipelineDB
PipelineDB is an open-source relational database that runs SQL queries continuously on streams, incrementally storing results in tables.
See all alternatives

TimescaleDB's Followers
57 developers follow TimescaleDB to keep up with related blogs and decisions.
Ayush Singh
D C
Aras Can Akin
Simon Rascovsky
Andy Cunningham
utku aslan
yogi4u
핑귤 핑귤
Alex Thinath
Mohamma76685757