Drupal suitable for music site with reviews and music database?
Hi all,
I've read the Getting Started but didn't get an answer there.
We have a website about music with, most importantly, news items, concert reviews and interviews, and album reviews.
For the album reviews we want to build a database of artists (eg. "Pink Floyd"), albums (eg. "The Wall"), releases (eg. "2LP, EMI, 1981"), and reviews. A review is about a single release, and written by a single reviewer. Reviewers can only write, they are assigned a review by the Review Editor, who decides which reviews are published. When the Reviewer checks the Finished box, the Reviewers can no longer edit their reviews.
Right now, a dozen reviews are published frequently in one long article (to avoid people linking to a single review and according our policy to mix reviews of well-known with unknown bands). The Review Editor (who is also a Reviewer) decides which finished reviews are included. If this (multiple reviews in a single issue) is a big problem, we can abandon this policy.
We need a CMS so people can write news and interviews more easily (now done in PHP and HTML), but the reviews section is a pain in the ass. I am currently trying to find ways to do this in Joomla, but then I would have to write a lot of PHP code myself and still have no good link between our database and the Joomla articles. It's hard to add a dropdown to an article in the Album Reviews category so the Reviewer can select which Artist - Album - Release the review is about and leave that dropdown box out of articles in other categories.
Is Drupal a better choice for us? I have some experience with Joomla, not with Drupal yet.
All advice is much appreciated!
Thanks,
Jerry