What is Digg?45 Comments
- qwuinc, on 10/10/2007, -1/+28http://amarok.kde.org/wiki/MySQL_HowTo
It even has a section for SQLite->MySQL conversion. Duh. - NJHewitt, on 10/10/2007, -0/+15Anecdotal evidence : These instructions were more helpful for me than the instructions in the actual Digg link. Also, it has made my 8000+ track database a little more responsive.
I like this feature of Amarok, it's a good example of the whole KDE ethic of not assuming that the default option is best for all users, and providing alternatives. I know some people complain that makes KDE too complicated, too many choices to make, but I appreciate the freedom granted. - indiefan, on 10/10/2007, -0/+13while Amorak has it's downfalls (reorganizing all "the"s under 't' on my ipod), having a mysql database of my music library was great. Really opened up my music to be used however i wanted.
- jopsen, on 10/10/2007, -2/+13AFAIK is defaults to SQLite... SQLite is a small sql database written in C, is has about a few hundred kb overhead... It's also used in firefox and various other project... Not anything bloated....
MySQL in Amarok is for those who have a HUGE music collection, I don't think it's relevant for the average user... But I haven't tested it.. - rondeth, on 10/10/2007, -0/+10Well, throw these magical ideas out there, genius. We're dying to hear them.
- geminitojanus, on 10/10/2007, -0/+9I think this might actually just be voodoo. Either the person in the article has hundreds of thousands of songs, or the Qt/KDE guys got something seriously wrong in their SQLite bindings (and I'm banking more on the former than the latter).
SQLite is blindingly fast when doing simple operations, especially for read-mostly databases like a music database. See: http://www.sqlite.org/cvstrac/wiki?p=SpeedComparis ... - leinir, on 10/10/2007, -0/+9Just to clarify a touch on this one :)
First of all - amarok's got its own SQLite bindings (we could for a number of reasons not use the QtSql classes, mainly because not enough distributions actually package them, at least when we originally wrote the abstraction layer).
Secondly, and more importantly, i would find it very likely that our Ubuntu-running friend does not have the most recent version of Amarok, which has gained a HUGE speed increase in SQLite (according to some tests done by the guy that wrote the patch, that i can't remember where is right now). i am making a comment on his blog enquiring on this :)
And lastly, a more direct and i hope interesting point... Have you seen the sort of things Amarok does with the database? It is not entirely simple operations - the statistics stuff is sort of hefty. It's not just "Get me songs by this artist on this album" it's also funky things like "Get me songs that are related to this artist from this rather long list that i just fetched from last.fm" ;) - leoedin, on 10/10/2007, -0/+9wait...are you claiming that your media player of choice *doesn't* use a database? amarok normally uses a built in database that's transparent to the end user. The ability to use a MySQL DB instead just shows flexibility.
- dwbell, on 10/10/2007, -0/+7I found the speed increase to be so great at 20,000 songs that I could never go back to sqlite. Changing to MySQL isone of the first things I do when changing distros. I don't know speed would first become noticeable, but MySQL is so much faster I'd guess a music collection that is in the 4 digit range would see a significant boost.
- steveway, on 10/10/2007, -1/+8I use a postgresql-database for my collection in Amarok.
It feels faster than Mysql, there are very detailed howto's at Amarok's official wiki. - amfantasy, on 10/10/2007, -0/+7I think you need a massive collection to really notice a difference.
- AnthonyA7, on 10/10/2007, -0/+7I've got about 5000 songs, and for me, Amarok is virtually unusable unless I use MySQL.
- k3nt, on 10/10/2007, -0/+7from your link:
"Default database backend is a lot faster due to a new SQLite version."
I think the idea is that the new SQLite is faster than the old SQLite, not faster than MySQL. - stmiller, on 10/10/2007, -0/+6http://amarok.kde.org/en/node/234
"Default database backend is a lot faster due to a new SQLite version."
One of Amarok 1.4.6's new features was the addition of a new SQLite version, which works faster than the mysql implementation. (Hence the name.)
This blog post is very....odd. I'm not sure why Mike says: "Of course, I chose the no set up required but slow speed option (SQLlite)."
SQLite is not the 'slow speed option'! - oobuntu, on 10/10/2007, -0/+5Author didn't mention how many songs he had -
How many songs in your collection do you need before this makes a noticeable difference to the speed? - Elfeckin, on 10/10/2007, -0/+4I'm loading in around 85000 songs or so..i was just complaining to my buddy last night about amarok being laggy with a large collection...ill see how the rescan goes and see if its any noticeable difference..
- oderdigg, on 10/10/2007, -0/+3I followed the instructions and enabled MySQL over SQLlite. Noticeable difference but not earth shattering. If you had 20,000 songs... I could this being a nice improvement.
- m6arate, on 10/10/2007, -0/+3i am the author.. I will add a link to http://amarok.kde.org/wiki/MySQL_HowTo
and I have about 4000 songs .. and I definitely noticed a huge improvement over lite - coldphoenix, on 10/10/2007, -2/+5Even after a 1000 songs, for me at least, performance improved when I switched to mysql
- chronniff, on 04/21/2008, -0/+2Great simple howto for the novice linux user as well as quick and simple for even a more advanced user who simply doesn't want to have to put any thought into the setup.....by the way, the difference in speed is earth shattering if you have an extremely large collection, especially when that collection is accessed remotely
- Urusai, on 10/10/2007, -3/+5Support real FOSS, don't use MySQL.
- inactive, on 10/10/2007, -0/+2You should be able to use an embedded H2 database. This one is incredible fast.
- mikelieman, on 10/10/2007, -0/+2I'm wondering if there are Perl bindings for SQLite? Get access to the stuff without needing to change anything about Amarok. ( Which is *OK*, but seems to go crashy-crashy too often for my tastes... )
- majinboy, on 10/10/2007, -0/+2I also have ~1000 songs, but for me amarok 1.4.6 was quite slow using the Sqlite DB, every time a track changed, one core would shoot up to 20+% usage. Switching to Mysql solved that. Now running 1.4.7 and Mysql, it is much smoother than Sqlite.
Btw, I have a Core Duo T2500 (2.0 GHz), 2GB RAM and is running Gentoo. - wattersm, on 10/10/2007, -0/+2Yes, there are. Just about every language works with SQLite.
- Megatog615, on 10/10/2007, -1/+3This potentially can allow multiple computers to use the same database, right? I've tried connecting my laptop's Amarok to my desktop's Amarok MySQL database and had lots of problems.
- stmiller, on 10/10/2007, -0/+2D'oh! You are right. Mod me down, I misread the blurb on Amarok's page.
- Elfeckin, on 11/14/2007, -0/+1i never responded...hahah...yeah its much quicker now that im doing the mysql data base...WOO!!!
- NJHewitt, on 10/10/2007, -0/+1Yep, that's how it is now. Read the article, to change from the default, you go through a preferences menu.
New people do get started immediately. - oderdigg, on 10/10/2007, -1/+2I have nearly 1000 songs in Amarok and I find SQlite to be very fast. Never complained about speed.
I'm using v1.4.7 and I have a C2D 1.83GHz w/ 2 GB ram running 64bit Ubuntu and a 7200 rpm HD. - eean, on 10/10/2007, -0/+1Just backup the whole database.
- disector88, on 10/10/2007, -1/+2Agree! Still needs a lot of improvements man - users should be able to search for any metadata of the file - file name would be _really_ nice!
- adt41287, on 10/10/2007, -1/+2i have about 6,000 songs, i cant wait to try this! i hate waiting around for Amarok, i always just thought i was over working my computer.
- flashingcurser, on 10/10/2007, -0/+1Yes, but you must pre-mount it before scanning it. You can set this up in fstab to mount your smb shares on startup. A good idea is to have a public directory in /home, like /home/Music and automount that on startup. Set amarok to scan it. Another cool thing you can do is have the mysql back end on a different server, that way all your playlists on all of your machines are the same and only one needs to scan the smb share. Make sure they all have the /home/Music directory.
Oh and you can browse an smb share and manually add the songs to your current playlist. - prototypef, on 10/10/2007, -0/+1i haven't used the sqlite database in amarok, and i can attest to the fact that the mysql performs extremely well with a collection of 10,000 songs, but using mysql always felt a little overkill. i'm not sure if the advantage of using a faster database outweighs the fact that using it means you need to have a mysql daemon running all the time, using up cpu, memory and other system resources (unless, of course the database is remote). In my case it didn't matter since i was running the mysqld for developing webapps anyways. For standard desktop use the sqlite database, especially the newer versions, should do just fine.
- lonniebiz, on 10/10/2007, -0/+1I'd rather a default be chosen to begin with, and then I'll discover preferences through a preferences menu.
This allows new people to get started immediately without potentially unnecessary configuration. - coldphoenix, on 10/10/2007, -3/+3Most people rename their file names to match the tags...or vice versa
- jbond, on 10/10/2007, -0/+0Regardless of the backend, can Amarok on Ubuntu actually cope with scanning large numbers of songs from an SMB share yet? Having faster collection handling is irrelevant if you can't actually scan it in the first place.
- tehmoth, on 10/10/2007, -2/+1so instead of replying to someone using MySQL, you chose to reply to someone using a much freer database. congratulations.
- verevi, on 10/10/2007, -4/+2I've never gotten a good answer to, "How do I backup and restore my ratings/play-counts from any of the databases???"
- daldredge, on 10/10/2007, -9/+3Someone who can't understand the difference between i and I doesn't have any business installing a 'database' server.
- Wronghead, on 10/10/2007, -9/+2Who is Kevin Rose and why did he own me so badly?
- AnthonyA7, on 10/10/2007, -9/+2I've got about 5000 songs, and for me, Amarok is virtually unusable unless I use MySQL.
- NJHewitt, on 10/21/2007, -10/+1Anecdotal evidence : These instructions were more helpful for me than the instructions in the actual Digg link. Also, it has made my 8000+ track database a little more responsive.
I like this feature of Amarok, it's a good example of the whole KDE ethic of not assuming that the default option is best for all users, and providing alternatives. I know some people complain that makes KDE too complicated, too many choices to make, but I appreciate the freedom granted. - inactive, on 10/10/2007, -18/+5Kinda stupid that a media player requires a ***** DB server.
Very overkill. Immediately a handful of better alternative solutions, more practical ones, come to mind.
Check out the new & improved 
© Digg Inc. 2009
— Content created and posted by Digg users is