amarok database

[Mark Kretschmann]

On 3/5/08, Ian Monroe <ian at monroe.nu> wrote:
> On Wed, Mar 5, 2008 at 1:55 PM, Caleb Cushing <xenoterracide at gmail.com> wrote:
>  >  are there any plans to improve the design of the sql database for amarok 2?
>  >  I've recently learning a lot about sql and think that the 1.4.x design could
>  >  be improved in several ways.
>  >
>  >  I am willing to help with this, if the project is interested. I unfortunately
>  >  don't know c++ (at least enough to say I can program in it). But I think that
>  >  I get SQL more than I do procedural or object oriented languages.
>  >
>  >  I would like to see amarok support multiple user's sharing the same collection
>  >  going forward while having there own ratings/scores and playlists. It would
>  >  be excellent if amarok could handle this on a single user environment (e.g.
>  >  one user account on the system). I'm pretty sure I could design the db to
>  >  handle this but I don't think I could do the front end work. There are of
>  >  course other things that I think could be improved.
>
> We've already redid a lot of how our database works in Amarok 2.

That being said, we could still make very good use of your offer. Most
of us Amarok developers are not very proficient with SQL, to say the
least. Having an expert help us could be very useful, especially with
optimizing queries for performance.

Currently Amarok 2 only supports the SQlite backend, but we have plans
to switch this over to MySQL Embedded (or, at the user's choice,
normal MySQL). But we don't really want to support multiple database
backends any more. If you could help us researching the use of MySQL
Embedded for Amarok, that would be extremely helpful.

-- 
Mark