I have a set of STI models, each have slightly different attributes.
While I could create a row for each one, I feel that there may be too
much null data in the database. At the moment I setup a has_many to a
parameters table which stores key value pairs. I want to find the best
solution for performance and simplicity.
-
STI for each field (I think new fields will be needed more than not,
and will require a lot of migrations) -
Parameters has_many association. Seems like overkill, not sure if I
am getting a performance hit here. -
Serialize params via YAML or Marshal
Any recommendations? Performance is primary concern, simplicity second.