SQLite Forum

What would be the recommended way to hold an array of ~600 double values?
Login
Right, so more like two 16-bit ints and a double, allowing up to 64k presets and 64k values per preset before the rows start getting larger.

If you add in my "store ADC measurements as ints" idea, the double becomes a 1-bit int for 8-bit ADCs or a 2-bit int for any reasonable ADC beyond that, since ADCs beyond 16-bit are exceedingly rare outside of audio-land.