Music ratings system

[Peter]

Originally posted here: http://code.google.com/p/streeme/issues/detail?id=21

I'd like to propose the ability to rate music (1-5 stars) from the web
interface. I'd be willing to take a shot at this, but first I want to
check on the feasibility of the idea. I'm not sure about this, but I'm
going to assume that the mp3 database is stored in mysql. So using
that same database, create another variable per song that includes the
rating. After that, adding another column in the desktop web interface
with stars to click on shouldn't be too difficult. Any thoughts/
comments/criticisms are welcome.

If this ability can be added, as well as the proposed android
improvements, I wouldn't need a local player ever. Playlist import
would also be helpful to import ratings.

Response from Rich:
I think a rating system would be sweet. would you want it to write to
the file or just save in the database somehow? I'm a bit worried about
putting it in the database, because there's a chance that the records
could be deleted and take your ratings with it. If you did it on the
file itself, I think there might be a ratings API built into the
windows (and other) filesystems. Alternatively, we could rate per
album and store it with the album art records. I might also be
interested in leaving comments about it too, to make the music content
more searchable. Might be a good topic to move to the discussion board
here: http://groups.google.com/group/streeme

[Peter]

You're right, it should probably be written to the file itself. I'm
90% sure both comments and ratings are built into the windows
filesystem (not sure about linux or mac, but probably those too). So
we'd need to modify the function that scans media for tags to also
pull the rating and comment fields. I'll look into it a bit more when
I get some time.

[Rich]

Yeah - if we can find a simple API for this, it would be pretty slick.
The ratings you set in Streeme would be available to other programs on
your computer too.

-Rich

[Joe Jiko]

This might be helpful:
Common Media Properties
..
PKEY_Rating WM/SharedUserRating
from: http://msdn.microsoft.com/en-us/library/ff384862%28v=vs.85%29.aspx#related_topics

[Rich]

Whoa awesome.. that's a good solution for Windows - doesn't even look
hard to implement.. what does OSX/Linux Unix have?

-Rich

On Apr 1, 7:47 am, Joe Jiko <joej...@gmail.com> wrote:
> This might be helpful:
> Common Media Properties
> ..
> PKEY_Rating     WM/SharedUserRating

> from:http://msdn.microsoft.com/en-us/library/ff384862%28v=vs.85%29.aspx#re...
>

[Peter]

I'm not sure if linux even has that capability yet. I did some google
searches and that yielded nothing. I believe each linux application
maintains its own rating system. For mac, it may be safe to assume
that most mac users will also be using itunes. When you "export
library" in itunes, it creates an xml file that contains various
things including the music rating. I'm most interested in the Windows
version, and it seems to be the most straightforward.