I wonder how to store best multiple boolean values in ecto/any other orm. Lets assume it will be 10 true/false values which most of the time will be similar but not always and I won’t search by these values. I can either:
- create 10 columns-which will most of the time store the same values-It does not fool right to me,
- Store it as json in one column-then I can search this column
- have an value/pointer that points to a separate table with the values-most of the time these are similar so it might be only a couple of rows so less indexing
- in rails I found also a gem attr_bitwise that stores up to 32bit values as 1 integer - from my pov this makes the most sense
What are your thoughts?