2.13.0
/ 28 November 2023; 5 months ago (2023-11-28)[2]
Repository
https://github.com/timescale/timescaledb
Written in
C
Operating system
Cross-platform
Type
Time series database
License
Apache 2.0
Website
timescale.com
TimescaleDB is an open-source time series database[3][4][5] developed by Timescale Inc. It is written in C and extends PostgreSQL.[6][7] TimescaleDB is a relational database[8] 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.[9]
One of the key features of TimescaleDB is its performance, which has been compared to InfluxDB.[10] Time-based data partitioning provides for improved query execution and performance when used for time oriented applications.[11] More granular partition definition is achieved through the use of user defined attributes.[12]
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).[13]
^Miller, Ron (5 May 2021). "Timescale grabs $40M Series B as it goes all in on cloud version of time series database". techcrunch.com.
^"TimescaleDB v2.13.0 release notes". Retrieved 29 November 2022.
^Design Recommendations for Intelligent Tutoring Systems: Volume 8 - Data Visualization. Army Research Laboratory. December 29, 2020. p. 50. ISBN 9780997725780. 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 singluar 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.
^Dr. Quan Ha Le; Marcelo Diaz (13 August 2021). Developing Modern Database Applications with PostgreSQL. Packt Publishing. p. 162. ISBN 9781838641061. 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.
^Nathan Liefting; Brian van Baekel (26 February 2021). Zabbix 5 IT Infrastructure Monitoring Cookbook. Packt Publishing. p. 358. ISBN 9781800208452. TimescaleDB is an open source relational PostgreSQL database for time-based series data.
^Baer, Tony (June 17, 2021). "Timescale scales out and sets its sights on analytics". zdnet.com. 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.
^Grzesik, Piotr; Mrozek, Dariusz (2020-05-25). "Comparative Analysis of Time Series Databases in the Context of Edge Computing for Low Power Sensor Networks". Computational Science – ICCS 2020. Lecture Notes in Computer Science. Vol. 12141. pp. 371–383. doi:10.1007/978-3-030-50426-7_28. ISBN 978-3-030-50425-0. PMC 7302557.
^Struckov, Alexey; Yufa, Semen; Visheratin, Alexander A.; Nasonov, Denis (2019-01-01). "Evaluation of modern tools and techniques for storing time-series data". Procedia Computer Science. 156: 19–28. doi:10.1016/j.procs.2019.08.125. ISSN 1877-0509.
^"High Volume Space Exploration Time-Series Data Storage in PostgreSQL". InfoQ. Retrieved 2021-08-04.
^Jowanza Joseph (December 6, 2021). Mastering Apache Pulsar(Ebook). O'Reilly Media. ISBN 9781492084853. TimescaleDB shares some philosophical and performance characteristics with InfluxDB, a database supported out of the box by Pulsar IO.
^Martin, Steven J. (2018-09-01). "Cray Advanced Power Management Updates" (PDF). CUG Proceedings 2018. Retrieved 2021-08-04.
^Jinka, Preetam (2018-12-05). "Time Series at ShiftLeft". Medium. Retrieved 2021-08-04.
TimescaleDB is an open-source time series database developed by Timescale Inc. It is written in C and extends PostgreSQL. TimescaleDB is a relational...
Archived from the original on 2013-09-27. Retrieved 2013-06-25. "Debian - Icinga DB". icinga.com. Retrieved 2024-03-25. "Icinga2 Changelog". GitHub. October 2022...
open NC office". Mobi Health News. "Timescale announces $15M investment and new enterprise version of TimescaleDB". Techcrunch. January 29, 2019. "Quizlet...
Strassert JF, Irisarri I, Williams TA, Burki F (March 2021). "A molecular timescale for eukaryote evolution with implications for the origin of red algal-derived...
the purpose of the study is to assess this isolated effect Has a short timescale between its implementation and maturity of its effects And the causal...
is the fifth of six ages of the Late Cretaceous Epoch on the geologic timescale of the International Commission on Stratigraphy (ICS). In chronostratigraphy...
solutions for up to 3 weeks but that gradual changes occurred over longer timescales. Sterile water samples have been observed to be less susceptible to speciation...
baseline of solar magnetic field and solar irradiance on a millennial timescale". Scientific Reports. 9 (1): 9197. arXiv:2002.06550. doi:10.1038/s41598-019-45584-3...
"Interactions between climate and tropical cyclones on all timescales") Wang, C., S.-K. Lee and D.B. Enfield, 2008: Climate response to anomalously large and...
surface convection zone is sharp and the convective timescales slower than the pulsation timescales, the convective flows react too slowly to perturbations...
1086/429523. PMID 15795855. S2CID 17021360. San Mauro, D. (2010). "A multilocus timescale for the origin of extant amphibians". Molecular Phylogenetics and Evolution...
S2CID 7041325. Battistuzzi FU, Feijao A, Hedges SB (November 2004). "A genomic timescale of prokaryote evolution: insights into the origin of methanogenesis, phototrophy...
However, recent research suggests one-and-a-half- to two-fold millennium-timescale changes in the cosmic ray flux in the past forty thousand years. The magnitude...
Astrophysics. 353: 163. Bibcode:2000A&A...353..163N. "On a cosmological timescale, The Earth's period of habitability is nearly over | International Space...
characterized by abrupt beginnings and endings (with changes taking place on timescales of decades or centuries). The Younger Dryas is the best known and best...
NMR spectrum of PF5 since NMR spectroscopy operates on a millisecond timescale. Electron diffraction and X-ray crystallography do not detect this effect...
1086/429523. PMID 15795855. S2CID 17021360. San Mauro, D. (2010). "A multilocus timescale for the origin of extant amphibians". Molecular Phylogenetics and Evolution...
loss. Most will react with oxygen in the air to form oxides over various timescales (potassium burns in seconds while iron rusts over years). Some others...
hydrogen burning via the CNO cycle may keep these white dwarfs hot on a long timescale. In addition, they remain in a bloated proto-white dwarf stage for up...
residence time of carbon dioxide in the atmosphere may require a millennium-timescale commitment to aerosol injection if aggressive emissions abatement is not...
Chinese). Vertebrata PalAsiatica 20 (1) :83-87 See for a detailed geologic timescale Gradstein et al. (2004) Butler, R.J. (2005). "The 'fabrosaurid' ornithischian...