2012-10-02, 09:25
jmarshall and myself have discussed the following approach: Replace the "art" table in the videodb/musicdb with a table that holds the art_id, media_type, media_id and a column which contains an array of all the artwork for that item in JSON. That will allows as to join that column into the different views (based on the media_type and media_id) and get all the artwork even though it's a 1-to-many relation. I haven't had the time to code and test it yet though.