TimescaleDB Production Ready
Written by Kay Ewbank   
Thursday, 08 November 2018

TimescaleDB, an open-source PostgreSQL extension for time-series that is optimized for fast ingest and complex queries, has been released as production ready by its developers.

TimescaleDB has already been downloaded over a million times, and there are production deployments at Comcast, Bloomberg, and Cray. This 1.0 release offers native Grafana integration and  Prometheus support. TimescaleDB supports full SQL and is designed to scale well. The developers say it can ingest millions of data points per second; scales tables to 100s of billions of rows and 10s of terabytes; and when used for time-series data is much faster than InfluxDB, Cassandra, MongoDB, and vanilla PostgreSQL.

In addition to Grafana and Prometheus, TimescaleDB supports Tableau, Apache Kafka, Apache Spark, and Zabbix. Features designed for managing time-series data include automatic space-time partitioning, a hypertable abstraction layer, and adaptive chunk sizing. It also supports geospatial analysis and JSON format data.

Improvements in this release over the earlier release candidate include easier to use time-series manipulation functions, including an explicit arbitrary datetime with which to start time bucketing for common aggregation functions (e.g., September 1), as well as aligning weeks starting from Monday to respect the ISO standard.

Management of multiple tablespaces has also been improved to allow hypertables to elastically grow across many disks, and there's more information available about the state of hypertables, their dimensions, and their chunks when creating and managing data.

This release also improves the foundation for a database scheduling framework that manages background jobs. This will be used in future releases to add more automation around areas such as automatic data aggregation, retention, and archiving.

The native support for Grafana includes a new visual query editor for the PostgreSQL/TimescaleDB datasource, so that users don’t have to write SQL to access their data. Both the query editor and the underlying PostgreSQL datasource have been written by TimescaleDB developers as part of Grafana's open source code.


timeseriesdb 

 

More Information

TimescaleDB Website

Related Articles

Open Source Time Series Database Released

PostgreSQL 11 RC Available

PostgreSQL Improves Declarative Partitioning 

PostgreSQL Adds Parallel Query Support

PostgreSQL Version 9.5

PostgreSQL 9.4 Released

PostgreSQL Plus Cloud Database

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin.

Banner


GitHub Launches Draft Pull Requests
18/02/2019

GitHub has added a way to show other developers that a pull request is code that is work in progress or even just an idea on how you're thinking of creating code.



Developers Break Out Of The App Store
19/02/2019

It's not so much a breakout, more a sort of bending of the rules. After Google and Facebook were shamed by Apple because they misused their enterprise developer certificates, it now appears that the p [ ... ]


More News

Python

 



 

Comments




or email your comment to: comments@i-programmer.info