Click to See Complete Forum and Search --> : making a mp3 database...


[Mystik_Cool]
03-02-2003, 06:39 AM
Hi,

I'd like to create a database, listing all my mp3's. Up to there, that's not really difficult. In fact, I even have one that I did with MS Access (from Office 97) a long time ago.
I'd like to see some fields in this database : Artist, Song Title, Genre and Rating. The Genre would be "rock/electro/...", and the Rating would be a number from 0 to 10, illustrating if I like this song or not. Up to there, even my sister could do it (with a lot of time lol)

But I'd like to use this database to choose mp3's. There would be a little prog using this database, which could access it and choose songs, based on some input like "genre" or "minimal rating". If you don't see the utility of such an app, think that I have thousands of mp3 and I'm tired of zapping until I find a good song, then enjoy it for 3min, then zap again...
So the goal would be to be able to run this little prog, specify for example "rock" and a minimal rating of "5", and it would play only songs corresponding to these criteria.

I'm really not a programmer so I don't know anything (or then very a little) about databases and programming languages. So, before updating my database, I'd like to know : what would you use to do this ? (for the database, and the language for the little prog). And do you think I could start from the old database I made with Access under win (maybe in exporting it in another format...) ?

Thanx a lot for any help.

Seminole
03-02-2003, 09:06 AM
I would suggest searching freshmeat for such a thing.

Here is the list that was turned up for me.
http://freshmeat.net/search/?q=MP3+AND+MySQL&section=projects

There are several web based systems and a few that don't require the web. Not too many have a rating system but I fouond one written in Java that may be just what you are looking for.

http://freshmeat.net/projects/mp3cattle/?topic_id=113

That one is not web based and appears to have a rating feature and genre support.

http://freshmeat.net/projects/mp3organizer/?topic_id=123
This one appears to have a rating system also (screenshot).

I did not go past the first page. You should be able to find something on the three pages returned.

Good Luck!

[Mystik_Cool]
03-02-2003, 10:48 AM
Waouw ! I wanted to do it by myself but... as it seems to be already done... :D
That's really close to what I imagined ! Maybe that, when I'll have some free time, I'll try to edit my own, but for the moment mp3cattle will be fine...

Thanx a lot !