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

Leftovers: Ubuntu and Debian

  • Ubuntu Studio 16.04 Wallpaper Contest
    This poll is for the selection of 16 desktop wallpapers for Ubuntu Studio 16.04.
  • Debian LTS Work January 2016
    This was my ninth month as a Freexian sponsored LTS contributor. I was assigned 8 hours for the month of January. My time this month was spent preparing updates for clamav and the associated libclamunrar for squeeze and wheezy. For wheezy, I’ve only helped a little, mostly I worked on squeeze.
  • Welcome to Parsix GNU/Linux 8.5r0 Release Notes
    Parsix GNU/Linux is a live and installation DVD based on Debian. Our goal is to provide a ready to use and easy to install desktop and laptop optimized operating system based on Debian's stable branch and the latest stable release of GNOME desktop environment. Users can easily install extra software packages from Parsix APT repositories. Our annual release cycle consists of two major and four minor versions. We have our own software repositories and build servers to build and provide all the necessary updates and missing features in Debian stable branch.

Raspberry Pi/Devices

  • Another new Raspbian release
  • How do geeks control their lights?
    We made this setup to test our capabilities to control Arduino with Raspberry Pi in our upcoming big project. We did not have spare keyboard and screen for RPi, so we ended up ssh-ing into the Pi via Wi-Fi router.
  • How To Start A Pirate FM Radio Station Using Your Raspberry Pi
    Continuing our Raspberry DIY series, we are here with a simple tutorial that tells you how to start your own pirate FM station using Raspberry Pi. Take a look and broadcast your tunes — anytime, anywhere.
  • Tizen 3.0 on the Raspberry Pi 2
    The Samsung Open Source Group is currently in the process of porting Tizen 3.0 to the Raspberry Pi 2 (RPi2). Our goal is to create a device capable of running a fully-functional Tizen 3.0 operating system, and we chose the RPi2 because it is the most popular single-board computer with more than 5 million sold. There are numerous Linux Distributions that run on the RPi2 including Raspbian, Pidora, Ubuntu, OSMC, and OpenElec , and we will add Tizen to this lineup. We face a number of obstacles in accomplishing this, but we hope this will serve as a model for bringing Tizen to a broader range of hardware platforms.
  • Embedded 14nm Atom x5-E8000 debuts on Congatec boards
    Intel released several new 14nm Atom SoCs, including an embedded, quad-core x5-E8000 part with 5W TDP, now available in four Congatec boards. Intel released the Atom x5-E8000, the first truly embedded system-on-chip using its 14nm Airmont architecture. Airmont is also the design that fuels Intel’s Celeron N3000 “Braswell” SoCs and its mobile-focused Atom x5 and x7 Z8000 “Cherry Trail” SoCs. The x5-E8000 is the heir to the 22nm Bay Trail generation Atom E3800 family.

Android Leftovers

FSF/GNU/GPL/FSFE

  • Winning the copyleft fight
    Bradley Kuhn started off his linux.conf.au 2016 talk by stating a goal that, he hoped, he shared with the audience: a world where more (or most) software is free software. The community has one key strategy toward that goal: copyleft licensing. He was there to talk about whether that strategy is working, and what can be done to make it more effective; the picture he painted was not entirely rosy, but there is hope if software developers are willing to make some changes. Copyleft licensing is still an effective strategy, he said; that can be seen because we've had the chance to run a real-world parallel experiment — an opportunity that doesn't come often. A lot of non-copyleft software has been written over the years; if proprietary forks of that software don't exist, then it seems clear that there is no need for copyleft; we just have to look to see whether proprietary versions of non-copyleft software exist. But, he said, he has yet to find a non-trivial non-copyleft program that lacks proprietary forks; without copyleft, companies will indeed take free software and make it proprietary.
  • The Trouble With the TPP, Day 27: Source Code Disclosure Confusion
    Another Trouble with the TPP is its foray into the software industry. One of the more surprising provisions in the TPP’s e-commerce chapter was the inclusion of a restriction on mandated source code disclosure. Article 14.17 states: No Party shall require the transfer of, or access to, source code of software owned by a person of another Party, as a condition for the import, distribution, sale or use of such software, or of products containing such software, in its territory.
  • I love Free Software Day 2016
    In the Free Software society we exchange a lot of criticism. We write bug reports, tell others how they can improve the software, ask them for new features, and generally are not shy about criticising others. There is nothing wrong about that. It helps us to constantly improve. But sometimes we forget to show the hardworking people behind the software our appreciation. We should not underestimate the power of a simple "thank you" to motivate Free Software contributors in their important work for society. The 14th of February (a Sunday this year) is the ideal day to do that.