I've inherited an EAV database and there's really no option to remodel it. Data is stored as key_name, key_value pairs Trying to return a meaningful, unified recordset is far too complex to be efficient. I've decided to make use of the MySQL GROUP_CONCAT, and CONCAT_WS functions to return a fast query result, with the consolidated fields as one string. The final data is to be displayed and downloaded (CSV), but not all fields will be available for each "row", which makes serialization awkward. I can't decide where the "heavy lifting" should go to parse and process this data for screen and download.
Does anyone have a good strategy for this? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
