I have a set of data that I want to store in a sqlite3 (though I’m considering other options as well) table. The issue is I want to store this data in long format, but many of the columns have the same values for multiple rows in long format.
e.g., suppose I have columns col1, col2, col3, col4, ..., col10 where the first 6 columns will have the same values for every group of 10 rows. So from a storage perspective this seems rather wasteful. Are there optimizations that can be made in the schema for this?
5