TimescaleDB

{{Short description|Open-source time series database}}

{{Infobox software

| name = TimescaleDB

| logo =

| developer = Timescale Inc{{cite web |last1=Miller |first1=Ron |title=Timescale grabs $40M Series B as it goes all in on cloud version of time series database |url=https://techcrunch.com/2021/05/05/timescale-grabs-40m-series-b-as-it-goes-all-in-on-cloud-version-of-time-series-database/ |website=techcrunch.com|date=5 May 2021 }}

| released = {{Start date and age|df=yes|2018|11|01}}

| latest release version = 2.15.0

| latest release date = {{release date and age|df=yes|2024|05|08}}{{cite web

| url = https://docs.timescale.com/timescaledb/latest/overview/release-notes/

| title = TimescaleDB v2.15.0 release notes

| accessdate = 10 May 2024

}}

| latest preview version =

| latest preview date =

| repo = https://github.com/timescale/timescaledb

| programming language = C

| operating system = Cross-platform

| genre = Time series database

| license = Apache 2.0

| website = {{URL|https://www.timescale.com/|timescale.com}}

}}

TimescaleDB is an open-source time series database{{cite book |title=Design Recommendations for Intelligent Tutoring Systems: Volume 8 - Data Visualization |date=December 29, 2020 |publisher=Army Research Laboratory |isbn=9780997725780 |page=50 |url=https://books.google.com/books?id=TxY6EAAAQBAJ&dq=%22TimescaleDB%22+-wikipedia&pg=PA50 |quote=For example, the emergence of reliable, open-source, timeseries databases, such as InfluxDB and TimescaleDB, have made them indispensable tools upon which to build metric-driven workflows (Assay, 2019).The value in these specialized data-stores is in their singular focus around ingesting and vending massive amounts of tagged measurements at specific points in time. The optimization and specificity to common issues related to measurement in general --- as well as their open-source licenses --- have made them indispensable solutions for a wide range of needs requiring measurement at scale.}}{{cite book |author1=Dr. Quan Ha Le |author2=Marcelo Diaz |title=Developing Modern Database Applications with PostgreSQL |date=13 August 2021 |publisher=Packt Publishing |isbn=9781838641061 |page=162 |url=https://books.google.com/books?id=f4k4EAAAQBAJ&dq=%22TimescaleDB%22+-wikipedia&pg=PA162 |quote=TimescaleDB is an open source database for time series data; we first heard about TimescaleDB when we investigated standalone PostgREST because it had TimescaleDB as a built-in extension.}}{{cite book |author1=Nathan Liefting |author2=Brian van Baekel |title=Zabbix 5 IT Infrastructure Monitoring Cookbook |date=26 February 2021 |publisher=Packt Publishing |isbn=9781800208452 |page=358 |url=https://books.google.com/books?id=nhMZEAAAQBAJ&dq=%22TimescaleDB%22+-wikipedia&pg=PA358 |quote=TimescaleDB is an open source relational PostgreSQL database for time-based series data.}} developed by Timescale Inc. It is written in C and extends PostgreSQL.{{cite web |last1=Baer |first1=Tony |title=Timescale scales out and sets its sights on analytics |url=https://www.zdnet.com/article/timescale-scales-out-and-sets-its-sights-on-analytics/ |date=June 17, 2021 |quote=Thus, TimescaleDB joins what is literally a crowd in the PostgreSQL community, but it is unique in being one of the few, if not the only, PostgreSQL variants that have been specifically designed for time series data. |website=ZDNet}}{{Cite book|last1=Grzesik|first1=Piotr|last2=Mrozek|first2=Dariusz|title=Computational Science – ICCS 2020 |chapter=Comparative Analysis of Time Series Databases in the Context of Edge Computing for Low Power Sensor Networks |date=2020-05-25 |series=Lecture Notes in Computer Science|volume=12141|pages=371–383|doi=10.1007/978-3-030-50426-7_28|pmc=7302557|isbn=978-3-030-50425-0}} TimescaleDB is a relational database{{Cite journal |last1=Struckov |first1=Alexey |last2=Yufa |first2=Semen |last3=Visheratin |first3=Alexander A. |last4=Nasonov |first4=Denis |date=2019-01-01 |title=Evaluation of modern tools and techniques for storing time-series data |journal=Procedia Computer Science |language=en |volume=156 |pages=19–28 |doi=10.1016/j.procs.2019.08.125 |issn=1877-0509 |doi-access=free}} and supports standard SQL queries. Additional SQL functions and table structures provide support for time series data oriented towards storage, performance, and analysis facilities for data-at-scale.{{Cite web|title=High Volume Space Exploration Time-Series Data Storage in PostgreSQL|url=https://www.infoq.com/news/2018/10/space-time-series-data/|access-date=2021-08-04|website=InfoQ|language=en}}

One of the key features of TimescaleDB is its performance, which has been compared to InfluxDB.{{cite book |author1=Jowanza Joseph |title=Mastering Apache Pulsar |date=December 6, 2021 |publisher=O'Reilly Media |isbn=9781492084853 |url=https://books.google.com/books?id=eYBTEAAAQBAJ&dq=%22TimescaleDB%22+-wikipedia&pg=PT121 |language=English |format=Ebook |quote=TimescaleDB shares some philosophical and performance characteristics with InfluxDB, a database supported out of the box by Pulsar IO.}} Time-based data partitioning via hypertables provides for improved query execution and performance when used for time oriented applications.{{Cite web|last=Martin|first=Steven J.|date=2018-09-01|title=Cray Advanced Power Management Updates|url=https://cug.org/proceedings/cug2018_proceedings/includes/files/pap174s2-file1.pdf|access-date=2021-08-04|website=CUG Proceedings 2018}} More granular partition definition is achieved through the use of user defined attributes.{{Cite web|last=Jinka|first=Preetam|date=2018-12-05|title=Time Series at ShiftLeft|url=https://blog.shiftleft.io/time-series-at-shiftleft-e1f98196909b|access-date=2021-08-04|website=Medium|language=en}}

TimescaleDB is offered as open source software under the Apache 2.0 license. Additional features are offered in a community edition as source available software under the Timescale License Agreement (TLS).{{Cite web|date=2020-09-24|title=TimescaleDB License Agreement|url=https://www.timescale.com/legal/licenses|access-date=2021-08-09}}