Language Selection

English French German Italian Portuguese Spanish

MySQL in Amarok 2 - The Reality

Filed under
Software

Jeff Mitchell: There has been a lot of chatter lately regarding Amarok's switch to MySQL as its only SQL backend. A decent amount is FUD -- either by people simply pushing back against change, or by people that simply don't understand the decision. Some of it (particularly Adriaan's blog post) has been insightful and interesting, but miss the mark in terms of why this change was made. This post attempts to explain why this decision was made, what it really means for you the end-user, and why you should have a cup of tea and relax.

I want to point out first that I said that MySQL is going to be Amarok's only SQL backend. A2's collection system is very powerful. Just take a look at how varied music sources from Shoutcast, Jamendo, Magnatune, Ampache, MP3Tunes, as well as local sources like iPods and your local file system, are treated as equals in A2. A collection is a collection, and is limited only by what capabilities it advertises it can support (and of course, it can supply its own custom capabilities). It's not currently enabled, I don't think, but there's a Nepomuk-based collection option too. So take heart -- this change only affects Amarok's internal SQL collection, and not other sources (although those sources can store information in the SQL database if they wish to cache information).

Since I mentioned Nepomuk, it's time to discuss another common question/demand/complaint: KDE has this nice Strigi-Nepomuk thing going on...why aren't we using it for scanning music and storing information?

Rest Here




Why Nepomuk could not fully replace (My)SQL in Amarok

This is another post about collection backends in Amarok. The others posts explained the switch to MySQL embedded and tried to address some of the concerns. Jefferai also wrote a few things about Nepomuk in Amarok (and why it will not fully replace the sql based collections) which I want to comment on and add to.

There are user asking: “There is Nepomuk in KDE for storing meta data why the switch to MySQL embedded you could just use Nepomuk and drop sql collection all together.” With reasons like: “Nepomuk can do this and that better and one storage in KDE for everything is best.” They are not complete wrong, there are good reasons to use Nepomuk (data sharing between applications, system wide searching, using strigi(and taglib) for collection scanning at a central place for all applications once, interconnect the data with other data (like let Kmail store where I got that song from), and others)

But Jefferai is right when he says that Nepomuk can not replace the sql collection for everyone and every use case. At least not for the short and longer midterm (Wink).

Why?

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

More in Tux Machines

Phoronix Benchmarks

Leftovers: Software

  • Are you Struggling With Finding Text In Files Or Locating Files? Try 'Recoll' Program In Linux
    Recoll is a full text search QT based free, open source program especially made for Unix-like and Linux but it is also available for Windows and Mac systems, licensed under GPL. It provides efficient desktop full text search from single-word to arbitrarily complex boolean searches, basically it indexes the documents data (along with their compressed versions) and huge number of files then let you find quickly whatever you search for. Recoll updates its index at designed intervals (for example through Cron tasks) but if desired, the indexing task can run as a file-system monitoring daemon for real-time index updates.
  • New Inkscape 0.92 breaks your previous works done with Inkscape
    I hope this type of blog-post will shake the mindset a bit, and make developers more serious about compatibility. The users shouldn't be prompted with a dialog with jargon. The artwork or rendering shouldn't be broken. Inkscape should do the auto-conversion to keep the artwork as it was (especially because the software can). Isn't it the task of Inkscape to be able to read SVG? to properly read itself? I hope a version 0.92.x will happens and solve this serious bug [1] . For those who have been following my work for the last ten years, I like to promote the release of new Free/Libre and Open-Sources Software versions. It costs me a lot emotionally and in production-time to have to make this type of blog-post against a project I love. But what else can I do?
  • Ardour + Cinelerra + 4 Cams + Heavy Blues
  • Albert Quick Launcher 0.9.0 Released With External Extensions Support
    Albert is a quick launcher for Linux inspired by Alfred (Mac). It can be used to run applications, open files, search the web, open bookmarks in your web browser, calculate math expressions, and more.
  • MKVToolNix 9.8.0 Open-Source MKV Manipulation App Adds Support for DVB Subtitles
    Moritz Bunkus released today, January 22, 2017, a new stable release of his popular, multiplatform, and open-source MKV (Matroska) manipulation utility for all supported platforms, including GNU/Linux, macOS, and Microsoft Windows. There are bunch of exciting new features added in the new MKVToolNix 9.8.0 release, which comes three weeks after the previous version, namely MKVToolNix 9.7.1, but first we'd like to inform package maintainers about an important change in the build system as parallel builds are now enabled by default.
  • Libvirt 3.0 Released With Various Improvements
    The libvirt virtualization API saw a major 3.0 release this week to succeed its earlier v2.5 milestone.
  • 5 Highly Promising Terminal Emulators
    The terminal emulator is a venerable but essential tool for computer users. The reason why Linux offers so much power is due to the command line. The Linux shell can do so much, and this power can be accessed on the desktop by using a terminal emulator. There are so many available for Linux that the choice is bewildering.
  • What Spotify Takes Away, the Open-Source Community Brings Back…
    One of my favourite bands has just released a new album, which means I now have 11 new songs to learn the words to before I go see them play next!
  • Skype for Linux Alpha Video Call Support Begins ‘Rollout’

today's howtos

Wine Staging 2.0 RC6