gSoC Implement a better database schema

[Mark Kretschmann]

2009/3/26 Ben K <mrmrpotatohead at gmail.com>:
> Fixing that bug doesn't require a schema change; you just write nulls
> instead of zeros and change the handling of the two values.
>
> The Amarok devs spent quite a lot of time coming up with new schema used in
> Amarok 2, and I suspect they'll be reluctant to change it. There were also
> quite specific reasons for moving to MySQLe and only MySQL backend - it
> means far lower support costs than when you have potentially 3 different
> backends (you don't have to manage three sets of interfaces).
>
> I like your suggested behaviour for ratings, and null seems to me to be the
> way to represent unrated, given that null means 'no information', but I
> don't think this is an entire GSoC project. You could probably fix 172112 in
> a few days of coding. Why don't you give it a shot and submit a patch to the
> bug?

I could probably whip up a wordy reply, but in essence the thing is:

Ben is right.

-- 
Mark Kretschmann
Amarok Developer
www.kde.org - amarok.kde.org