Company
Date Published
Author
Brock Friedrich
Word count
2994
Language
English
Hacker News points
None

Summary

This installment of the "Community Member Spotlight" series highlights the work of Shane Steidley, director of software at Density, and Brock Friedrich, software engineer. They explain how they are using TimescaleDB to query data from IoT devices to help companies with substantial real estate footprints make data-driven decisions to optimize their real estate usage while reducing carbon emissions. Density is a company that builds technology to help companies understand how people use physical space. They use sensors and analytics platforms to provide comprehensive insights into how spaces are used, allowing companies to compare a space's performance against its intended purpose, other spaces, or portfolio benchmarks. The team uses TimescaleDB to store counts of people in spaces over time and to perform continuous aggregates, which have been a game-changer in their development process. They find that using TimescaleDB has made development faster and more efficient, allowing them to offload decision logic and complexity around time zone handling and bucketing to the database. The team is now moving towards ETL-type processing out of the database but still utilizing continuous aggregates for rolling up high-resolution data to lower resolutions. They recommend resources such as the Timescale blog and advise developers to consider real-time use cases and historical use cases separately when designing a scalable database or strategy around an analytic workload.