Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Slackware This Forum is for the discussion of Slackware Linux.


  Search this Thread
Old 04-28-2008, 10:31 AM   #1
LQ Newbie
Registered: Nov 2007
Posts: 15

Rep: Reputation: 1
Question Amarok with MySQL support?

I know that this is probably not the best place to ask, but do you know why the standard (current) amarok package does not include MySQL support? Because when amarok is built with the support, it can use both sqlite and MySQL, so there is no problem in using default sqlite if MySQL is not running.

I am just curious, I've built amarok package with mysql myself. I just wanted to know if any of you may be aware of any reason Thanks
Old 04-28-2008, 10:55 AM   #2
Registered: Jun 2004
Location: USA
Distribution: Slackware
Posts: 137

Rep: Reputation: 21
I don't know the answer, but if I had to guess, I would say it's because sqlite is more than adequate for amaroK's needs.

And if you'll allow me to be curious, why would you want to use MySQL for amaroK? Ok, I assume you have MySQL running on your machine for other reasons, but it really is overkill when you consider amaroK's modest db needs.

As a follow up question, even if you do need MySQL running on your system for other processes(as I assumed) why not use sqlite for amaroK anyway? It has practically no overhead and the entire db is comprised of a single file (making backups dead simple, btw). In fact, I think the entire sqlite library is built into the amaroK code, so you aren't even wasting space by having/using it.

Please don't take this as a flame, I'm just curious.

BTW: anyone interested should check out out FLOSS Weekly episode 26 for a really informative interview with the creator of sqlite, Richard Hipp.
Old 04-28-2008, 12:40 PM   #3
LQ Newbie
Registered: Nov 2007
Posts: 15

Original Poster
Rep: Reputation: 1
I don't know about other users' needs , but for me, MySQL performs better with my (quite big) music library (about 13,000 songs). The response for searching is noticeably faster. Amarok uses 22 tables and saves things like lyrics or vaious statistics into the db... the total size of db is 17.46MB... (later addition: as I checked now, amarok uses the db quite often, during my uptime the average is about 0.75 queries/s)

That is the only reason why I use MySQL (inside amarok, not on my system )

The whole MySQL supports does not need anything additional, just configure the package with "--enable-mysql" which creates slightly bigger application, so it's not a big deal, that's why I'm asking...

No flame As I said, MySQL suits my needs more than sqlite.

BTW: Thx for interesting link...

Last edited by macbeth8; 04-28-2008 at 12:50 PM.
Old 04-28-2008, 08:24 PM   #4
Registered: Jun 2004
Location: USA
Distribution: Slackware
Posts: 137

Rep: Reputation: 21
If MySQL works best for you, that's cool. Choice is the beauty of Linux, after all. I forgot that amaroK stores lyrics too - that can really adds to the size of your db.

As for my comments about overkill and overhead, let's just say that old habits die hard. I hate to sound like an old man (cause I'm not), but I have been using computers for nearly 20 years and I am still struggling to get that we've reached a point in computing where we needn't really worry much about the overhead of background processes. The continually decreasing cost of hardware has made it so that it's cheaper and easier to add more 'muscle' than to mind our running processes.

Anyway, sorry I wasn't able to provide a solid answer.

As for the FLOSS Weekly podcast, I've listened to them all and it's not bad. They focus on applications or projects and not solely on the Linux kernel and distros - which is nice. I think Leo LaPorte would be more of an open source user/advocate if he had the time, and well, I imagine most linux people probably know who Randall Schwartz is.
Old 04-30-2008, 06:33 PM   #5
Senior Member
Registered: Jul 2007
Distribution: Slackware64-14.1
Posts: 2,366

Rep: Reputation: 835Reputation: 835Reputation: 835Reputation: 835Reputation: 835Reputation: 835Reputation: 835
I initially used sqlite in Amarok, but after adding a certain number of songs the database somehow got screwed up (no, my computer didn't crash, and nothing else was messed up at all) and playcounts, ratings etc. were reset after exiting Amarok. After rebuilding Amarok with MySQL support (using the official SlackBuild and just changing the one build option), I can now use a MySQL database and all is working again. Now, if something messes up, I can manually check stuff using MySQL to see WHY it's messing up. Maybe it's possible with sqlite as well, but I don't know anything about using it manually. Old habits do die hard, and I just prefer MySQL anyway.


amarok, current, mysql

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Amarok only support mp3 svennand Linux - Desktop 3 02-13-2007 10:36 AM
m4b support for amarok rutgerw Linux - Software 1 03-07-2006 04:39 AM
Can't get MySQL support in amaroK mwales Linux - Software 1 02-02-2006 12:49 PM
amaroK mp3 support true_atlantis Fedora 2 08-28-2005 01:17 PM
Amarok and! RoaCh Of DisCor Linux - Newbie 2 06-21-2005 08:40 PM > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 09:37 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration