|
Electronic music voting database - needed?
|
View this Thread in Original format
| mindbender |
Hi fellow trancEaddicts :)
I have been designing a database which would enable users to evaluate different songs by giving them a grade (1-10), some comments etc. The DB and the entire system will be accessible with a web browser. I was wondering if you people have some good feature suggestions or an opinion if such system is worth building or not. Any comments are highly appreciated, thanks.
Here's a short feature list of the things I had in mind:
- add a new track to the DB (edit/delete)
- add a new producer/DJ to the DB (edit/delete)
- evaluate/vote for track (give grade, comment etc)
- automatically generate top lists showing total points, average score, comments
- lists of 1. new tracks 2. top by genre 3. top by DJ/Producer/User, 4. top by location 5. all tracks by DJ/producer
- discussion threads for different tracks etc.
- submit your own top XX
Each track would have these parameters:
- producer name
- track name
- remixer/remix label
- release date
- genre
- availability (cd, vinyl, mp3 etc)
- short description of the track style
- links to samples/mp3 etc
- points, avg grade, comments
Why do this?
At least I have found 90% of awesome tunes because someone else has recommended those tracks. This service would help people to find great music, find out about new tracks and discuss things in more focused manner.
How to do this?
The easiest and the most flexible approach is to use Lotus Notes/Domino since the actual functionality doesn't have to be very complex. I have an alpha version working already.
What do you think? Any ideas?
|
|
|
| Swamper |
I could do this in about an hour using PHP/MySql....
But...
You're being too detailed... To get that much data on every track is a nightmare.. since for a lot of them you'll have empty fields and that's just no good..
Eventually this whole site will be database driven.. I'll move the voting stuff from cgi to php as well as everything else....
Start small and build... or else... you'll get overwhelmed & pissed off.. trust me :D
|
|
|
| Anscoop |
Starting small and building ends you up with bloated code. That's one of the first lessons one should learn as a programmer.
UBB is the perfect example of that.
Of course, you can start small but you have to keep in mind key objects and code in a careful and atrochiously slow manner, to make expansion easier and efficient, but then you end up taking the same amount of time as doing it full out from the start.
I would say you have a very good idea mindbender, and it would make a quite popular site.
|
|
|
| Swamper |
Looking at coding from an OOP point of view building compartmentalized pieces of code that accomplish their task efficiently and are later called upon IS what you want to do.
...for this sort of thing altering a table in a database later on is hardly a big deal. |
|
|
|
|
