let's say you have a data type where a large chunk of the data is often null and only occasionally has a value.
Uncategorized
2
Posts
2
Posters
6
Views
-
let's say you have a data type where a large chunk of the data is often null and only occasionally has a value. would you normalize the data such that every piece of data is a column and you just have a bunch of nullable rows or would you just throw all the nullable stuff in a jsonb column? or something else?
#databases #postgres -
let's say you have a data type where a large chunk of the data is often null and only occasionally has a value. would you normalize the data such that every piece of data is a column and you just have a bunch of nullable rows or would you just throw all the nullable stuff in a jsonb column? or something else?
#databases #postgres@0x4d6165 especially if the nullable columns tend to be an "all or nothing" thing where either most of them are set or none of them, you could put them in a separate table and only create a row if there is non-null data for it -
R relay@relay.mycrowd.ca shared this topic
