Add `group` filed to `labels` table?

Lukas 1lukas1 at gmail.com
Sat Jan 9 22:12:29 CET 2010


Hi,

I really like the idea of having labels to tag tracks in Amarok, but I find
it a bit limiting, as the count of labels is going to grow.

It is quite easy to get hundreds of different labels as you keep using
Amarok for a long time. Its not bad thing as thats why they are created for,
but browsing them can became too complicated.

having group field could help dealing with it. Lets say labels sad, happy,
angry, nice would became members of mood group, slow, fast - speed etc.

Even more, If i understood right, labels is going to be used to serve
functionality of multiple artists and genres. Thats one of the most wanted
functionality o a music player i want, but having to browse labels cloud of
1000+ entries where most of them is artists wont be very comfortable.

So having labels marked as being members of some groups would be easy to
filter out unwanted ones.


To store groups i would suggest using either 'enum' (mysql limit -
65,535different elements)or 'set' (mysql
limit - 64 different entries) type, instead of using separate table for
that, as groups are not going to be changed often also i don't see a point
having more than 5-12 groups. Even more, choosing set type  would allow a
label to belong to more than one group, in case if artists name would match
genre etc. Less joins, less ram used, more performance gained :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/amarok-devel/attachments/20100109/c2d1db07/attachment.htm 


More information about the Amarok-devel mailing list