Home / Companies / Tiger Data / Blog / Post Details
Content Deep Dive

Looking at States and Dwell Time With HyperfunctionsRemoved

Blog post from Tiger Data

Post Details
Company
Date Published
Author
James Blackwood-Sewell
Word Count
702
Company Posts That Month
9
Language
English
Hacker News Points
-
Post removed?
Yes
Summary

The text discusses a problem of calculating dwell time or connection time for devices transitioning between states, such as power meters or network-connected devices. It mentions that the solution to this problem can be found using TimescaleDB's hyperfunctions, which are high-performance Rust functions designed for time-series analysis. The author provides a SQL query using state_agg and state_timeline hyperfunctions to calculate dwell times for each device in the given dataset. This solution was not available five years ago when the author first posted about this problem on Timescale Slack, but it is now possible with the addition of over 100 hyperfunctions to TimescaleDB.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.