Catching Waves with Time-Series Data
December 13, 2024
30 min
Free
time-series-data
data-modeling
database-design
postgresql
timescale-db
clickhouse
data-aggregation
data-compression
api-design
data-retention
Description
Time-series data is remarkably common, with applications ranging from IoT to finance. Effectively storing, reading, and presenting this time-series data can be as finicky as catching the perfect wave.
In order to understand the best-practices of time-series data, we’ll follow a surfer’s journey as she attempts to record every wave she’s ever caught. We’ll discover how to structure the time-series data, query for performant access, aggregate data over timespans, and present the data via an API endpoint. Surf’s up!