I’m starting an application that will create, persist, query, and
display timeseries. I’m wondering how to best store these timeseries
so they can be queried via metadata. Each timeseries object could be
seven or eight metadata attributes and an array of say 80000
integers. There could be 10000 or more timeseries. The timeseries
values will be appended but not modified in place. I’d like to use
the ActiveRecord / Rails approach here and was wondering whether
BLOBs attribute, a filesystem or a combination approach makes sense
for marshalling the array of values to a compact format.