timescaledb-toolkit
timescaledb-toolkit copied to clipboard
timescale
Extension for more hyperfunctions, fully compatible with TimescaleDB and PostgreSQL 📈
Two tests in our `flat_serialize` crate fail when run under [Miri](https://github.com/rust-lang/miri), a Rust interpreter that can detect some undefined behavior: ``` $ cargo miri test --target x86_64-unknown-linux-gnu ... failures: ----...
**Problem** I am working with a database of billions of timeseries GPS points. I would like to determine the spatial/temporal/class distribution of certain variables with the end goal to be...
**Is your feature request related to a problem? Please describe.** I've been wondering if `percentile_agg()` could support `rolling()` like `stats_agg()` does; this would allow us to write more efficient percentile...
**Is your feature request related to a problem? Please describe.** Helping the community, we often see cases like [this](https://stackoverflow.com/questions/68937639/calculating-the-change-of-a-value-versus-the-last-reading-in-timescaledb/68939299#68939299) where people want to use last value as some expression. Transposing...
**Describe the bug** Queries like `SELECT stddev(stats_agg(price) OVER (PARTITION BY symbol ORDER BY time RANGE '15 min' PRECEDING) FROM stocks_real_time WHERE symbol = 'AAPL'` while significantly more performant than the...
**Relevant system information:** - OS: Timescale Managed Service Azure - PostgreSQL version: 14.4 - TimescaleDB Toolkit version: 1.10.0 - Installation method: Timescale Managed Service Azure **Describe the bug** Time weighted...
pgx 0.5.0 [adds a prelude](https://github.com/tcdi/pgx/pull/699). Instead of importing `pgx::*` everywhere, we can now do `use pgx::prelude::*` instead and not import everything (importing everything pollutes the scope of the importer and...
In [this CI run](https://github.com/timescale/timescaledb-toolkit/actions/runs/3039522886/jobs/4894540214), the `random_stress` test for `udd_sketch` had a random failure due to an unexpectedly high error: ```none thread 'tests::random_stress' panicked at 'Failed to correct match 0.51 quantile...
Note: I'm illustrating the issue through the use of * the `counter_agg()` and `toolkit_experimental.gauge_agg()` aggregates * their respective `delta()` and `toolkit_experimental.delta()` accessors * the `->` operator for function pipelines I...
**Is your feature request related to a problem? Please describe.** We have very irregularly sampled data, e.g. sometimes a value is valid for hours if the corresponding asset is idle...
