From: Peter Booth <pbooth@...>
Date: 2006-11-10T13:08:03+09:00
Subject: Ruby/MySQL/Rails timeseries QN

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.