MySQL is often used to store time-series data. But it doesn’t offer a way to interpolate between time points which is useful in a lot of data analysis work.
(Interpolation is used to estimate values for periods between where you have actual measurements, and allows you to look at your data in a more continuous fashion representative of how things occur in the real world).
This can be a problem if you have granular time series data and want to analyze them at an aggregated level.
Example Problem: Interpolating Between Water Meter Readings
The easiest way to explain the problem and the hack I’ve used is to go through an example.