Full SQL. Connect anything that speaks to PostgreSQL.
High rate writes. Performant complex queries. 100+ billion rows per server.
Engineered up from PostgreSQL. Inherit 20+ years of reliability.
Unlock the power of full SQL: complex WHERE predicates (with secondary indexes), aggregations and orderings, window functions, JOINs, CTEs, subqueries, statistical functions, and more. Your team and tools already know how to speak to TimescaleDB.
Store hypertables in the 100s of billions of rows, spread over tens of thousands of chunks, even while maintaining high ingest rates (independent of hypertable size). Individual hypertables can scale up across dozens of disks.
TimescaleDB automatically spreads data written to a hypertable into many dynamically-created chunks. Hypertables present the abstraction of a single table, yet transparently partitioned by time and space, they enable high insert rates even at billions of rows.
Hypertables look like standard PostgreSQL tables. So use your favorite visualization or BI tools, ORM front-ends, dashboards, admin and backup tools, pub-sub systems, log or metrics collectors, and more. A rich 20 year ecosystem that’s ready-to-use today.
Specify complex predicates for selecting on time intervals, strings, numerical thresholds, statistical functions, geo-spatial regions, etc. Aggressive constraint exclusion minimizes the chunks queried, and local indexing (btree, hash, gin, gist, brin) can ensure efficient lookup.
Efficiently join time-series data with traditional relational tables at query time (including metadata and other business data). Avoid maintaining a separate TSDB and relational DB, and the glue code and complexity needed for operating both.
Leverage the power of PostGIS with TimescaleDB for geo-temporal analysis. Calculate distances and boundary crossings, determine containment within complex polynomial regions, align readings to geometries, or analyze movements over time.
TimescaleDB and PostgreSQL are not just about fixed schema, but also have rich support for JSON/JSONB, including data validation and rich indexes (btree, gin, hash). Particularly useful for monitoring data and sparse metadata labels.
Advanced functionality not found in a NoSQL database: Triggers for pre- or post-processing writes; UPSERTs for merging or idempotently re-inserting data; constraints for data integrity checks, foreign-key relationships, and more.
Easily specify data retention policies on a per-hypertable basis. Store raw data for weeks, aggregated data for months or years. Dropping old data is 1000s of times more efficient than deleting rows from traditional relational tables.
Manage TimescaleDB like a traditional PostgreSQL database, including support for streaming replication and hot standbys, point-in-time recovery, and easy backups. Works with standard pg_dump and pg_restore, and other tools you know and trust.
Ready for the enterprise. Specify access control policies at the database, table, column, or even row-level. Much like PostgreSQL, control individual or group privileges on reading or writing data, schema changes, or other administrative actions.
Trust in PostreSQL's 20-year open-source record and strong developer community.
Reuse known and trusted methods for backups, snapshots, replication, and other operational tasks.
Leverage your team's existing comfort with SQL and PostgreSQL.
Connect via standard ODBC, JDBC, or PostgreSQL for 3rd-party viz tools, BI tools, web platforms and ORMs.
“TimescaleDB is uniquely positioned in the time-series database market as the only serious player that scales up AND down, and natively supports a robust, proven SQL engine. There's a lot of value in being able to deploy the same tech on your IoT edge/gateway as you do in the cloud, and you can still leverage the full complement of SQL tools for reporting, administration, etc.”
- Shane O'Donnell, IoT Data Architect, Cree“Using timescale to meet our data needs has been a breath of fresh air after using influxdb for the last year. We can iterate faster, use well-known querying methods, and leverage other postgresql integrations.”
- Mike Schroll, CTO, DNSFilter“What's powerful about TimescaleDB is it offers a best-of-both-worlds solution with full SQL and scale, by leveraging architectural insights about the unique characteristics of time-series data. Combining that with the rich PostgreSQL ecosystem yields something compelling.”
- Ion Stoica, Professor at U.C. Berkeley, Co-founder & Chairman, Databricks"As our fleet of home security systems have grown, TimescaleDB has scaled seamlessly with us, while still allowing us to get quick answers to complex questions. This helps us keep our core product online, proactively monitor our devices, perform retroactive root cause analysis, and make sure our customers are happy.”
- Haomiao Huang, CTO, Kuna Systems"TimescaleDB is solving a real need with a powerful solution. They're an incredibly smart and driven bunch, and I've been really impressed with their product momentum so far.”
- Calvin French-Owen, CTO, Segment
