TimescaleDB System Properties

TimescaleDB is the first open-source time-series database that combines the reliability, query power, ease-of-use, and scalability required by today's software applications and data analytics infrastructure. All data can fundamentally be collected as time-series data and developers across all industries globally are recognizing this capability. TimescaleDB enables developers and data analysts to work with time-series data in more powerful and flexible ways by offering a system that:

Supports Full SQL
TimescaleDB natively supports full SQL and adds specialized functions (and query optimizations) for working with time-series data. Support for SQL, a query language your developers and business analysts already know, means that your team does not have to spend time learning a "SQL-like" syntax or custom query language. It also means JOINs with metadata are possible, allowing developers to simplify their stack and eliminate data silos.

Looks and feels like PostgreSQL
TimescaleDB scales PostgreSQL in ways previously reserved for non-relational systems and optimizes for fast ingestion on big data. In order to scale far beyond their relational counterparts, non-relational systems sacrifice query power and the flexibility that comes with the relational schema. TimescaleDB ingests millions of data points per second; scales tables to 100s of billions of rows; and returns quick responses to complex queries.

Works with entire PostgreSQL ecosystem
As a PostgreSQL extension, TimescaleDB inherits an operational interface familiar to developers, 20+ years of reliability work and allows users to leverage best-of-breed technologies by integrating with the entire PostgreSQL extension. This includes PostGIS, which adds GIS support for geo-temporal analytics. Additionally, with support for JOINs, users are able to consolidate their time-series data (stored in hypertables) with the relational metadata that gives it meaning (stored in standard tables), eliminating the data silos resulting from deployments where two different databases are used: one for time-series data and one for metadata. 

For more information, please view our documentation or join us in our active Slack Community

TimescaleDB is purpose-built to scale and handle time-series data workloads and is intentionally designed as a PostgreSQL extension.

TimescaleDB provides developers with capabilities that no other time-series database today can offer:

• Native support for ANSI SQL, including JOINs with relational metadata that can be stored right in standard PostgreSQL tables
  
• GIS support (via PostGIS, another PostgreSQL extension), which allows users to roll their own geo-temporal database
  
• Consistent, with support for ACID operations and transactions 
  
• Secondary indexes, including composite indexes
  
• Secondary JOINs
  
• Transparent in its resource utilization and performance (e.g., many options for administration and tooling, offers the ability to run EXPLAIN)

TimescaleDB is proven and enterprise ready, providing the reliability and tooling of PostgreSQL, enterprise-grade security, production-ready SLAs, and support. TimescaleDB offers the largest ecosystem of any time-series database including support for Tableau, Looker, Mode, Grafana, PowerBI, Apache Kafka, RabbitMQ, Apache Spark, Prometheus, Zabbix, JDBC/ODBC, and more.

IoT, Industrial Machine, and Sensor Data
Various industrial IoT use cases across manufacturing, mining, oil & gas, retail, healthcare, and more.

Modern Applications, Business Operations, and Data Pipelines
Developing modern SaaS applications, powering business operations and intelligence, and machine learning pipelines.

DevOps and Infrastructure Monitoring
DevOps and infrastructure monitoring, especially where siloed metrics are a concern and metadata is important.

Financial Information
Financial information and services across segments such as market research, commodities, and cryptocurrencies.

Altair Engineering Inc., Bloomberg, Comcast, Cray, Cree, DNSFilter, Laika, LaunchDarkly, Nutanix, Sailthru, ShiftLeft, SoFi, TransferWise, and many more.

1 million+ downloads, 6,500+ Github stars

Apache 2 and Timescale License (TSL); information on pricing for support and enterprise version available upon request