Not sure if the “How To” Forum is the ideal spot for this, but technical support didn’t seem right nor did general.

Regardless, I have used EE for a couple sites and working on some more as we speak.  I had done a site a while back that had a database of songs that I created custom with PHP.  This can be seen at http://www.straydoghaus.com/catalog/publishing.php. The rest of the site is driven by EE.  There have been a few feature requests to continue to enhance this solution and it made me curious if in hindsight it may have actually been beneficial to have used EE for this instead of creating the custom solution.

So my question is, is using EE setting up a weblog with possibly hundred if not thousands of song entries and then displaying then and being able to filter lists by categories as I had done in the site linked to above viable?

Would performance be an issue? 

Coule you relate say an artist from one web log entry, to multiple songs in a song weblog?

Seems like this could all be doable and would be interested in feedback from others regarding whether this is not the right tool for the job or should be considered for this type of use in the future?

Hi, Seth -

A song database is something that EE can easily handle, and the number of entries is no problem at all.  You might want to read up on relationships and reverse relationships as well.

Lisa Wess - 15 August 2007 09:54 AM

Hi, Seth -

A song database is something that EE can easily handle, and the number of entries is no problem at all.  You might want to read up on relationships and reverse relationships as well.

Thanks Lisa - I realize that I could have answered my own relationship question as I have used it to relate gallery images to a post to allow me to position and style an image precisely. Glad you wrote a brief answer to that .  From what I have seen and read I could have one relationship between one weblog and another or one weblog and a gallery entry. 

For a more complex case, it doesn’t seem I can have a many to many relationship. So Song A can be associated with Writer C and and Song B could be associated with Writer C, but am I right that Song A could not also be associated with Writer D in this scenario?

Hopefully that scenario makes sense.

I think my head just exploded. =)

You would need multiple custom fields for multiple relationships, or I believe Mark Huot has a “multi relation” extension that might help.