title: Best data model to store small fixed-length array in Postgres (with SqlAlchemy)
body: <p>I want to store a set of hourly set points. 24 floats (0. to 1.) that map hours of the day to an intensity value.</p>
  
  <p>I could:</p>
  
  <ol>
  <li>have 24 columns named <code>_0</code> to <code>_23</code>.
  (How can I extend db.Model in Sqlalchemy to use numbers as column names?)</li>
  <li>have a values table <code>(id, value, hour_of_the_day)</code>.</li>
  <li>use <a href="http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#sqlalchemy.dialects.postgresql.ARRAY" rel="nofollow">postgres array type</a>. (But it seems like I can't have fixed length arrays and I will need some application logic to get/set values.)</li>
  </ol>
  
  <p>The values will mostly be queried together and scaled (so that the range 0 to 1 maps) a custom range.</p>
  
  <p>Which model is preferable?</p>