Best data model to store small fixed-length array in Postgres (with SqlAlchemy)
<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>