MLH ยท Best use of Tiger Data

Powered by Tiger Data

A year of Apple Watch-style readings for a family of four lives in Tiger Data (TimescaleDB on PostgreSQL).

Hypertable
One big table that Tiger Data quietly splits into time-based chunks, so new readings stay fast to write and old ones stay fast to find.
Continuous aggregate
A summary (like each month's average) that the database keeps up to date by itself, so charts read a few rows instead of millions.
Compression
Older chunks are packed column by column, which shrinks the history a lot and can still be queried like normal.

Not medical advice. iCare shows trends and general information only. For anything serious or worrying, talk to a clinician. In an emergency, call 911.