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.