SQLite Forum

What would be the recommended way to hold an array of ~600 double values?
> The current format of these values is in a string.

At least you could use json by adding open and closed brackets `[10.23,0,12,...]`.  It allows you to use [json1](https://www.sqlite.org/json1.html) function to manipulate data. 

How to store data depends on your priorities: CPU, storage size, easy to view/changing and etc. There is no silver bullet.