Re: [Cooker] [Bug 21897] [amarok] New: amarok mysql backend missed

[Konstantinos Kostarellis]

On 4/9/06, Gertz RaphaÃl <rapsys@free.fr> wrote:

Le Vendredi 7 Avril 2006 08:30, martin.zboril@dizgrafix.cz a Ãcrit:
> User ID: 58613, 17 bugs reported (3 fixed, 0 duplicate, 6 invalid), 27
> comments.
>
> http://qa.mandriva.com/show_bug.cgi?id=21897
>
>       Distribution: cooker
>            Summary: amarok mysql backend missed
>            Product: amarok
>            Version: 1.4-0.beta3.2mdk
>           Platform: All
>             Status: UNCONFIRMED
>           Severity: wishlish
>           Priority: normal
>          Component: program
>         AssignedTo: lmontel@mandriva.com
>         ReportedBy: martin.zboril@dizgrafix.cz
>
>
> wow, even before they announced! but i am really missing mysql connection
> to database as amarok itself oftenly eat up +100MB of precius memory, i
> guess this solution is pretty rare either.. but why couldn't you? :)
> i am sorry for asking this silly questions, but i still don't know how to
> do my own packages, or compile the software correctly
You may add the mysql support, it's realy easy ;)

Just dl the src.rpm file, the do this :
urpmi rpm-build
rpm --rebuild amarok...src.rpm --with mysql
#urpmi all the missing deps + libmysql-devel

Then re-start rebuild, then replace the package with the just builded one ;)

I am not sure about --with mysql flag, see the spec file if it don't works
(rpm -i amarok...src.rpm; cd /usr/src/SPEC/; vim amarok.spec)

To be sure it compiled, look the result of the configure, if you see the mysql
backend will be build it's ok, else see what's wrong.

I am not sure we should enable mysql backend as it will increase the memory
eat of mysql (4.x% of 1GB memory is far enough I think).

we had this issue discussed a while before. And yes, even thou its annoying, a possible solution is to recompile amarok for yourself everytime a new release arrives. 

Reason for not compiling --with mysql / postgres was said the dependency system of rpm.
Additional there is original the plan on the Roadmap of amarok 1.4 to turn the database drivers into plugins (
http://amarok.kde.org/amarokwiki/index.php/RoadMap). Even thou nothing happened yet.

That's all known by now and still a little pain, but....
I'm wondering how rpm-based distros (fedora and others) is delivering amarok with sqlite, postgres and mysql enabled with still no dependency on mysql/postgres. Amarok solutes u with a little wizard were u can choose your database backend on them. Additional u can simply switch it in the amarok-preferences. I'd wish same functionality on the mandriva packages if in any way possible.