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

LWN (Now Open Access): Kernel Configuration, Linux 4.14 Merge Window, Running Android on a Mainline Graphics Stack

  • A different approach to kernel configuration
    The kernel's configuration system can be challenging to deal with; Linus Torvalds recently called it "one of the worst parts of the whole project". Thus, anything that might help users with the process of configuring a kernel build would be welcome. A talk by Junghwan Kang at the 2017 Open-Source Summit demonstrated an interesting approach, even if it's not quite ready for prime time yet. Kang is working on a Debian-based, cloud-oriented distribution; he wanted to tweak the kernel configuration to minimize the size of the kernel and, especially, to reduce its attack surface by removing features that were not needed. The problem is that the kernel is huge, and there are a lot of features that are controlled by configuration options. There are over 300 feature groups and over 20,000 configuration options in current kernels. Many of these options have complicated dependencies between them, adding to the challenge of configuring them properly.
  • The first half of the 4.14 merge window
    September 8, 2017 As of this writing, just over 8,000 non-merge changesets have been pulled into the mainline kernel repository for the 4.14 development cycle. In other words, it looks like the pace is not slowing down for this cycle either. The merge window is not yet done, but quite a few significant changes have been merged so far. Read on for a summary of the most interesting changes entering the mainline in the first half of this merge window.
  • Running Android on a mainline graphics stack
    The Android system may be based on the Linux kernel, but its developers have famously gone their own way for many other parts of the system. That includes the graphics subsystem, which avoids user-space components like X or Wayland and has special (often binary-only) kernel drivers as well. But that picture may be about to change. As Robert Foss described in his Open Source Summit North America presentation, running Android on the mainline graphics subsystem is becoming possible and brings a number of potential benefits. He started the talk by addressing the question of why one might want to use mainline graphics with Android. The core of the answer was simple enough: we use open-source software because it's better, and running mainline graphics takes us toward a fully open system. With mainline graphics, there are no proprietary blobs to deal with. That, in turn, makes it easy to run current versions of the kernel and higher-level graphics software like Mesa.

Beautify Your KDE Plasma 5 Desktop Environment with Freshly Ported Adapta Theme

Good morning! It's time to beautify your KDE Plasma 5 desktop environment, and we have just the perfect theme for that as it looks like the popular Adapta GTK theme was recently ported to Plasma 5. Read more

Roughing it, with Linux

I have been traveling for about two weeks now, spending 10 days camping in Iceland and now a few days on the ferry to get back. For this trip I brought along my Samsung N150 Plus (a very old netbook), loaded with openSUSE Linux 42.3. Read more

Red Hat: Ansible Tower, Patent Promise, and Shares Declining

  • Red Hat’s automation solution spreading among APAC enterprises
    Red Hat recently shared revealed its agentless automation platform is spreading among enterprises in APAC countries like Australia, China, India and Singapore. The company asserts its Ansible Tower helps enterprises cut through the complexities of modern IT environments with powerful automation capabilities that improve productivity and reduce downtime. “Today’s business demands can mean even greater complexity for many organisations. Such dynamic environments can necessitate a new approach to automation that can improve speed, scale and stability across IT environments,” says head of APAC office of technology at Red Hat, Frank Feldmann.
  • Red Hat broadens patent pledge to most open-source software
    Red Hat, the world's biggest open source company, has expanded its commitment on patents, which had originally been not to enforce its patents against free and open source software.
  • Red Hat expands Patent Promise
    Open-source software provider Red Hat has revised its Patent Promise, which was initially intended to discourage patent aggression against free and open-source software. The expanded version of the defensive patent aggregation scheme extends the zone of non-enforcement to all of Red Hat’s patents and all software under “well-recognised” open-source licenses. In its original Patent Promise in 2002, Red Hat said software patents are “inconsistent with open-source and free software”.
  • Red Hat Inc (RHT) AO Seeing a Consistent Downtrend
  • Red Hat, Inc. (RHT) noted a price change of -0.14% and RingCentral, Inc. (RNG) closes with a move of -2.09%