OCT
7
2008

Amarok 2 Second Beta Released

The Amarok Squad is proud to announce the second beta release of Amarok 2.0. This release includes a lot of bug fixes and improvements, like the switch from SQlite to MySQL-embedded. The LibriVox service is back, as is lyrics support. Please read the release announcement for a detailed list of changes since the release of Beta 1 and more.

The most significant change in this release is the switch from SQLite to MySQL-embedded as the database backend. MySQL-embedded allows us to use the performance increase of the popular MySQL database, while avoiding non-trivial configuration that comes with a standalone server. Most noticeably, you will see much improved performance of collection scanning and searching, especially with very large music collections.

More generally we have fixed a huge amount of bugs, bringing Amarok 2 one step closer to the stability you would expect for your daily music needs. While not quite stable quality, we encourage our users to test this release and continue submitting bug reports. Already this beta version is good enough for daily use in many cases.

We hope you enjoy this release which we have worked so hard to produce. Stay tuned for upcoming releases, and please do not forget to donate for Roktober!

Comments

Is there any paper that describes what Amarok2 should look like once its ready? I still don't understand the User Interface of the new release.


By Andre at Tue, 2008/10/07 - 5:00am

What part do you not understand? We'll be happy to explain.


By Mark Kretschmann at Tue, 2008/10/07 - 5:00am

I for one can't figure how to do edit the IDv3 tags of multiple files. (Album and Artits tags). Nor how to go to the next song in the play list when editing only one file.

Apparently there are missing features.

(Don't mean to sound like a whiner! I love Amarok and like the Fuzzy Playlists idea) Keep on amaRoking!


By PuercoPop at Wed, 2008/10/08 - 5:00am

I am trying to find out "Stop playing after this track" feature. What is very nice when you are leaving somewhere or going to sleep and you can just mark wanted song to be last in playlist, without dragging it as last one or anyother way reorganising or tweaking playlists.


By Fri13 at Thu, 2008/10/09 - 5:00am

This feature has not been forgotten. Please see this post for more information regarding missing features:
http://amarok.kde.org/blog/archives/809-Missing-features-in-Amarok-2.html


By Casey Link at Fri, 2008/10/10 - 5:00am

I have been following Amarok 2 using OpenSuse builds, and have not been able to work out how to get songs to be automatically scored. They all just sit a zero no matter how many times I play them. The play-count works, as does the rating (if it rate the files), but the score does not change, unless I change it.

Is this something I am missing, or something not yet done?

Amarok 2 is looking great - I am looking forward to the dynamic playlist being usable, as I think it looks better structured then the old one, but without scores, it is less useful.

Thanks...
Andrew


By Andrew Lowe at Wed, 2008/10/08 - 5:00am

Would you be so kind and tell me where to find suse builds of amarok2.


By toto at Wed, 2008/10/08 - 5:00am

This page lists the KDE repositories for Open Suse (straight to factory - 4.1):
http://en.opensuse.org/KDE/Repositories#KDE_4.1_Factory_Development

But the one you want is probably this:

http://download.opensuse.org/repositories/KDE:/KDE4:/Factory:/Extra-Apps...

It actually has amarok builds, pretty much daily. I am pretty sure you need to install the factory (4.1) builds of KDE for core, qt and perhaps community?

Hope this helps...


By Andrew Lowe at Wed, 2008/10/08 - 5:00am

Thanks :)


By toto at Wed, 2008/10/08 - 5:00am

There's a config option somewhere to use ratings, scores, both or neither if I remember correctly, maybe yours is off?


By NabLa at Wed, 2008/10/08 - 5:00am

I cannot find it in the gui... and had a look at the config files, but nothing giving any hints?

Anyone know the option or where I can find the options?

Thanks


By Andrew Lowe at Fri, 2008/10/10 - 5:00am

I'm pretty sure scoring has not been re-re-re-implemented after the script stuff changed. I have a feeling it slipped through the cracks... File a bug to remind us :)


By THIBOLOT at Fri, 2008/10/10 - 5:00am

I've just implemented it in my local Git repo.


By Mark Kretschmann at Sat, 2008/10/11 - 5:00am

Please add support to postgres :D


By Postgres at Wed, 2008/10/08 - 5:00am

why?


By sfdg at Wed, 2008/10/08 - 5:00am

Why not? Why should anyone install MySQL if he already have PostgreSQL installed and running? Just playing music is not an argument for running another one resources-consuming app. I'll better use mpd or whatever.


By GArik at Wed, 2008/10/08 - 5:00am

Yes, whatever is the right tool for the tool.


By Mark Kretschmann at Wed, 2008/10/08 - 5:00am

lmao


By illogic-al at Thu, 2008/10/09 - 5:00am

"Why should anyone install MySQL if he already have PostgreSQL installed and running? "
because even if someone has postgreSQL already installed AmarokTeam has to provide sane default configuration which just works. That is why providing embeded mysql is good idea, it will work out of box and still later you may switch to postgreSQL if you really want.
When we finally end this I'm-pro-user-I-want-insane-deault-configuration nightmare? Lets end it and start I'm-pro-user-,sane-default-configuration-is-v.good-and-I'm-happy-that-I-still-can-configure/tweak-it-the-way-I-want


By Koko at Wed, 2008/10/08 - 5:00am

For EXACTLY the same reason you guys could continue using Sqlite. The claim that the performance difference is too big is a joke.

Personally I dont mind because I agree that one should use the right tool for a given job and amarok developers decide what this is best for, but I dislike the argument that MySQL _needed_ to be chosen, as if it were significantly better than any other database.

And frankly I want flat files instead of databases ... ;-)


By markus at Fri, 2008/10/10 - 5:00am

I want flat files too!


By gentoo at Wed, 2008/10/15 - 5:00am

Hello Rockers,

today a very vital question came to my mind. How can I migrate from Amarok 1 to Amarok 2 once it's been released (a question that's actually a problem with all kde applications from qt 3 to 4). My problem is not so much the playlists and the library that can be done quite fast by hand my problem are my statistics which can't be moved so easy (afaik). Lately I was also asked if there was a plan/possibility to move ones iTunes statistics to Amarok 2 (once it's been released on win and mac too).

Sonnenschein


By Sonnenschein at Wed, 2008/10/08 - 5:00am

I believe someone is working on a script to import statistics from the 1 series to the 2 series. A quick search has turned up this gem.... so it looks like the devs think it is important
http://amarok.kde.org/blog/archives/708-Amarok-2-Artwork-is-Back.html

I also found this topic in regards to importing iTunes stats - but it seems to be for 1.4 series, but you could make it work...
http://amarok.kde.org/forum/index.php/topic,11902.0.html

Hope this helps...


By Andrew Lowe at Wed, 2008/10/08 - 5:00am

Correct, I have been working on a migration tool to carry over statistics from Amarok 1.4 to Amarok 2. I hope to include it in the next beta.

an iTunes library also shouldn't be difficult to import.


By Seb Ruiz at Wed, 2008/10/08 - 5:00am

I came up with the following to migrate the statistics from the old SQLite collection.db to the new mysqle database.

First: You have to start with a clean collection in Amarok 2. No statistics can have been recorded.
1. rm -r ~/.kde4/share/apps/amarok/mysqle
2. Start Amarok 2 and let it build the collection again, but do NOT play anything!!
3. Once the collection is fully built, quit Amarok completely.

You will need the MySQL server installed and configured. You probably already have it installed since Amarok 2 depends on it, so go ahead and give it an 'emerge --config' if you haven't already set it up. Remember the root password that you choose.

4. Now start the MySQL daemon if it's not already running:
# eselect rc start mysql

5. Move the Amarok database to the MySQL server's data dir:
# mv ~youruser/.kde4/share/apps/amarok/mysqle/amarok /var/lib/mysql/

6. Change ownership so MySQL can access it:
# chown -R mysql:mysql /var/lib/mysql/amarok

7. Now the magic foo:
# ( echo "SET sql_mode='ANSI_QUOTES';"
sqlite3 ~youruser/.kde3.5/share/apps/amarok/collection.db .dump |
grep '\(CREATE TABLE \|INSERT INTO "\)statistics' |
sed -e 's/\(CREATE TABLE \|INSERT INTO "\)statistics/\1old_stats/;s/,PRIMARY KEY([^)]*)//'
echo 'INSERT INTO statistics (url, createdate, accessdate, score, rating, playcount, deleted) SELECT id, createdate, accessdate, percentage, rating, playcounter, deleted FROM old_stats INNER JOIN urls ON (urls.rpath = old_stats.url);'
echo 'DROP TABLE old_stats;'
) |
mysql -u root -p amarok

It could take a minute for all the statistics to be migrated. Don't panic if it doesn't complete immediately.

8. Stop the MySQL server to be sure it has flushed everything to disk:
# eselect rc stop mysql

9. Change ownership back to your user and group:
# chown -R youruser:yourgroup /var/lib/mysql/amarok

10. Move the database back to Amarok's dir:
# mv /var/lib/mysql/amarok ~youruser/.kde4/share/apps/amarok/mysqle/

11. Start Amarok and appreciate that all your statistics are saved!


By Matt Whitlock at Fri, 2008/10/10 - 5:00am

I should have mentioned that these instructions are for Gentoo. Not much should change for other distros -- just how to install, configure, and start/stop MySQL, and possibly the location of the MySQL data dir.


By Matt Whitlock at Fri, 2008/10/10 - 5:00am

Amarok2 is really doing awesome, and i enjoy the new placement of the various parts!

the central pane contextview looks really promising, but is still a little clunky to use in comparison to the wikipedia/lyrics tabs of a1. But, nonetheless, I'm really looking forward to seeing where it will go :) like kde4 has done successfully, I'm sure amarok2 will successfully polish and complete it's new concepts post 2.0 release as well :)


By Vladislav at Wed, 2008/10/08 - 5:00am

Thank you :)

Continuing to improve Amarok 2 after the 2.0 release is definitely part of the plan.


By Casey Link at Fri, 2008/10/10 - 5:00am

Hurray...excellent... Congratulations for switching from Public Domain SQlite to commercial MySQL.


By anon at Wed, 2008/10/08 - 5:00am

You do realize that MySQL is GPL? (Which is imho better than public domain because it enforces sharing of changes!)


By tkjacobsen at Wed, 2008/10/08 - 5:00am

So is the SQlite also supported in addition to MySQL if I want link against instead of commercial MySQL?


By anon at Wed, 2008/10/08 - 5:00am

No, just like GTK+ is not suported if you want to link against it instead of commercial Qt...


By Jonno at Wed, 2008/10/08 - 5:00am

hahah. nice.


By illogic-al at Thu, 2008/10/09 - 5:00am

This is not correct. You can continue to keep it closed source IF you do not release it to the (outside) public. And as far as I know MySQL is not "GPL", MySQL is dual-licensed. And whenever something is dual-licensed it is incorrect to attribute it solely to GPL, because one would think it _IS_ only GPL licensed when it fact it has TWO licenses (like Qt has).


By markus at Fri, 2008/10/10 - 5:00am

Congratulations for the FUD


By Vide at Wed, 2008/10/08 - 5:00am

In other news, KDE decided to drop Qt because developers finally found out that it is also offered under a commercial license...


By gousiosg at Sat, 2008/10/11 - 5:00am

"I mean do we even know how many music files it takes for the overhead of MySQL (in terms of memory) to be worthwhile? " - Collection by yeah

Finally, nobody answered the above question. So, how many files does it take MySQL to show a difference over public domain SQLite? Ha ha ha ...take the challenge and show the FACTS.

How many files does it take to **ditch** a public effort to make an embedded database (SQLite), which strive to second to none, and embrace the commercial MySQL-embedded which Sun Microsystems anytime can close the source?

Show us why do you want to impose **ONLY** MySQL on us? I feel rather **suspicious** over this move.

You want to collect **public** donations to impose commercial products on us?

Why don't you ask a big donation from Sun Microsystems, the present owner of MySQL? For Sun to standardise MySQL-embedded, for people to not try the public domain SQLite, its a peanut marketing expense.

We are trying to escape from using commercial products specially as the parts of the structure or foundation of public open source products. If amarok is developed by a company for profit motive, then I don't have any argument at all.

People questioned the Qt is also a commercial product, released under GPL too, so what's the big deal? the big deal is the Qt **CANNOT** be taken away from us. Read this if you have no idea of what I'm talking about: http://www.kde.org/whatiskde/kdefreeqtfoundation.php

Does the dual-licensed MySQL-embedded also protected like that? If no, do you think Sun Microsystems will ever agree for a such a legal agreement?

If there is no hidden agenda behind this move, ie, switching from public domain SQLite to commercial MySQL-embedded, then what do we call this? This is utter stupidity. This is called foolishness. That is, no F idea what you are doing. No F idea **why** you are developing an open source product in first place. Wake up guys.


By anon at Sun, 2008/10/12 - 5:00am

<>

Why dont'you take the challenge yourself? Do you really think you are entitled to ask for numbers? If you want numbers to prove something you really need to stop asking everybody for generating numbers for you. You wouldn't trust them anyway, would you?

<>
Uhoh, are you living under a rock? I guess your PC is one of those hated commercial products too, an the table and the chair you are sitting at and the floor etc.. I could go on for hours... And by the way: Your are not <> so stop acting like it.

<>

No, really, Sherlock?


By Grow up! at Sun, 2008/10/12 - 5:00am

>>Finally, nobody answered the above question. So, how many files does it
>>take MySQL to show a difference over public domain SQLite? Ha ha ha ...take
>>the challenge and show the FACTS.

>Why dont'you take the challenge yourself? Do you really think you are entitled
>to ask for numbers? If you want numbers to prove something you really need to
>stop asking everybody for generating numbers for you. You wouldn't trust them
>anyway, would you?

Please understand, its not me who ditched the public domain SQLite and switched to commercial MySQL-embedded. The amarok developers should justify their switch. They should have numbers, I'm saying again, if there is no under the table deal with Sun Microsystems, they have no reason not to publish the numbers.

In fact, this is not a question of numbers or performance, this is a question of principals. We are discussing this on KDE website, not on Microsoft or Apple.

If performance is the issue, you are at the wrong place. You are on the wrong OS. You should use most probably Apple's Mac OSX and forget about open source, embrace with your whole heart the closed source.

You are on Linux, FreeBSD, etc. etc. because you have principals. You are not a fool or you are not a blind. You don't like the traps set by billion-dollar companies. You don't like software patents, you prefer to made advances already made by your peers, You are not a puppet billion-dollar companies can manipulate, you are a soldier with a cause.

The question here is, those who portray as the soldiers of freedom denied your freedom to use a public software product if you really want to use, which can never be taken away from you, (SQLite in this case) and imposed on your head a commercial product (MySQL-embedded in this case). You were not given a choice which easily could have given, did not even ask from you for the change, it seems do not even want to justify for the switch.

What all these explain:
1. People who develop amarok have no principals OR

2. There is a under the table deal with Sun OR

3. amarok is becoming a commercial product like their parent MySQL sold public sweat for more than a billion dollars.

What's the public can do:
1. Write to amarok developers and show your displeasure and ask them to support SQLite also.

2. Develop a patch to strip down MySQL-embedded code and use SQLite only or both. (This sure works)

3. Ask the amarok developers to accept the patch (if you support both MySQL-embedded and SQLite) and ask them to show they no hidden agenda.

Wake up guys, good luck.


By anon at Tue, 2008/10/14 - 5:00am

Sorry, guys, there is a spelling mistake.

Above "principals" should be corrected as "principles"


By anon at Tue, 2008/10/14 - 5:00am

Is the picture a hint that the new release contains an easter-egg?


By Casper Clemence at Wed, 2008/10/08 - 5:00am

Maybe ;)

The easter egg is well hidden this time. Good luck!


By Mark Kretschmann at Wed, 2008/10/08 - 5:00am

Amarok 1.4 had a rather nice equalizer. Is it going to appear in Amarok 2 as well?

Apart from missing that, I like what I see. :)


By Godji at Wed, 2008/10/08 - 5:00am

It will probably come back at a later point. Currently it's not supported by Phonon.


By Mark Kretschmann at Wed, 2008/10/08 - 5:00am

Is it possible to turn off MySQL when you don't have a large collection and would rather avoid the bloat? I mean do we even know how many music files it takes for the overhead of MySQL (in terms of memory) to be worthwhile?


By yeah at Wed, 2008/10/08 - 5:00am

No, it's not possible. Amarok is very much centered around the database; it's the heart of the program.

If you want a simple player without database I would rather suggest to use something like XMMS or its many clones.


By Mark Kretschmann at Wed, 2008/10/08 - 5:00am

Or perhaps even JuK, as it should already be default in your KDE install. Or at least easily avalibel in your package manager.


By Morty at Wed, 2008/10/08 - 5:00am

Yeah I guess I'll use JuK then.
Pity the devs weren't able to come up with a design that scales down though, that's not gonna help KDE's reputation of inefficiency


By yeah at Thu, 2008/10/09 - 5:00am

Amarok != KDE


By anon at Thu, 2008/10/09 - 5:00am

Okay but you didn't answer. How many music files does it take before using a full relational engine makes a significant difference?

I mean it's not I don't want to trust you, but I find it hard to because say Dolphin has no problem sorting views with tens of thousands of files very quickly, lots more than how many musics people have. So perhaps if you published stats which compares MySQL to a simple but well designed algorithm for 100, 1000, 5000 and 10000 music files it would be easier to trust you. Because otherwise it's hard to believe you I'm afraid, with my apologies.


By yeah at Thu, 2008/10/09 - 5:00am

Pages