timescale/timescaledb-toolkit 1.3.0

on GitHub

This release stabilizes many in-progress features, improves stats_agg, and introduces a new experimental feature, timevector function pipelines, to ease working with time-series data.

Stabilizations

• counter_agg helper functions for Prometheus-style resetting monotonic counters.
• hyperloglog efficient approximate COUNT DISTINCT.
• stats_agg two-step aggregate for common statistics.

Experimental Features

• timevector function pipelines. A compact and readable way to perform a sequence of analytic operations such as the following one for volatility

  timevector(ts, val) -> sort() -> delta() -> abs() -> sum()

• -> accessor for Toolkit types enables syntax like stats_agg(data) -> average()
• to_epoch() wrapper for extract ('EPOCH' FROM timestamp) that makes it work more like an inverse of to_timestamp(DOUBLE PRECISION) #251

Migration Warning

• This release changes the textual I/O format for Toolkit types. We are uncertain if we will need to do so again in the future. Due to this we currently only support dump/restore within a single version of the extension.

New Contributors

• @jonatas made their first contribution in #237
• @burmecia made their first contribution in #251

Full Changelog: 1.2.0...1.3.0