What is the best method to store matrix data in an SQLite Db?
The data is spread sheet type data consisting of cols and rows of primarily
numerical data.
I could have literally hundreds of the same type so I don't really want
to use a single table for each type and then have to id each row.
My first thought was Tables for each type group:
TYPE1
TYPE2
Storing the data as a csv BLOB.
Each Table will also have columns for Client, Project, and Case so I can
search on a combination of those three.
TABLE: TYPE1
rowid,CLIENT,PROJECT,CASE,CSVDATA
Am I in the ballpark??
James
The data is spread sheet type data consisting of cols and rows of primarily
numerical data.
I could have literally hundreds of the same type so I don't really want
to use a single table for each type and then have to id each row.
My first thought was Tables for each type group:
TYPE1
TYPE2
Storing the data as a csv BLOB.
Each Table will also have columns for Client, Project, and Case so I can
search on a combination of those three.
TABLE: TYPE1
rowid,CLIENT,PROJECT,CASE,CSVDATA
Am I in the ballpark??
James
Comment