Does this schema sound better suited for a document-oriented data store or relational?
- by Blaine LaFreniere
Disclaimer: let me know if this question is better suited for serverfault.com
I want to store information on music, specifically:
genres
artists
albums
songs
This information will be used in a web application, and I want people to be able to see all of the songs associated to an album, and albums associated to an artist, and artists associated to a genre.
I'm currently using MySQL, but before I make a decision to switch I want to know:
How easy is scaling horizontally?
Is it easier to manage than an SQL based solution?
Would the above data I want to store be too hard to do schema-free?
When I think association, I immediately think RDBMSs; can data be stored in something like CouchDB but still have some kind of association as stated above?