Re: [Rails] Dealing with an EAV database

2010-10-07 Thread Michael Pavling
I've read the rest of the thread with interest, but I just wanted to go back to the start for a second. On 6 October 2010 14:52, jrq wrote: > I've inherited an EAV database and there's really no option to remodel > it. Where have you inherited this data from? Is there an application that's still

[Rails] Dealing with an EAV database

2010-10-06 Thread jrq
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 q