I need a Music Player with mysql library similar to Amarok

Dankles · 02-27-2009, 10:24 PM

Anything out there? Since Amarok2 is dropping full mysql support for an integrated version, I need a new music library program.

I currently have a samba server with SQL and I access it from many computers with amarok. All computers use the same Amarok DB(the one on the central server/samba server) for indexes and stuff. I love this functionally but I wont have it anymore with the new amarok. So i need a new solution.

XavierP · 03-01-2009, 09:31 AM

Why do you say that Amarok is dropping MySQL support? Reading the Amarok2 announcement gives this:

Quote:

Some features, such as the player window or support for databases other than MySQL, have been removed because either they posed insurmountable programming problems, or they didn't fit our design decisions about how to distinguish Amarok in a saturated market of music players.

(my emphasis)

You don't have to update to Amarok2, I'm still on 1.something because I don't like the new interface. Maybe when it matures...

Also, mysqlite seems to support thousands of songs and gigabytes of data without any degradation or tweaking. Why do you need the full MySQL support?

i92guboj · 03-01-2009, 10:42 AM

Quote:

Originally Posted by XavierP

Why do you say that Amarok is dropping MySQL support? Reading the Amarok2 announcement gives this: (my emphasis)

You don't have to update to Amarok2, I'm still on 1.something because I don't like the new interface. Maybe when it matures...

Also, mysqlite seems to support thousands of songs and gigabytes of data without any degradation or tweaking. Why do you need the full MySQL support?

I don't follow the amarok2 stuff at all, it's not my cup of tea. However, my understanding is that it's not possible to use any external DB at all, even mysql. Or at least, it wasn't possible (I have no idea if that changed).

Yes, amarok2 has mysql support, but only through a builtin mysql copy, and not via a external server. But, as I said, I base this only on what I've read around the net (mainly in planetkde and affiliated blogs). I have no personal experience with amarok2, and probably never will.

XavierP · 03-01-2009, 11:36 AM

http://amarok.kde.org/wiki/MySQL_HowTo - for versions below Amarok2. As far as Amarok2 goes:

Quote:

Database Backend
MySQL embedded

Amarok uses the MySQL embedded package for database support, providing no fuss relational dbms which will scale well and provide excellent performance. Your MySQL installation must be compiled with the embedded server, please see Development/MySQL_Embedded

So you need to build MySQL with MySQLEmbedded support - but, as far as I can tell, it's still full MySQL.

Dankles · 03-01-2009, 02:05 PM

Quote:

Originally Posted by XavierP

http://amarok.kde.org/wiki/MySQL_HowTo - for versions below Amarok2. As far as Amarok2 goes:

So you need to build MySQL with MySQLEmbedded support - but, as far as I can tell, it's still full MySQL.

So if I have mysql with embedded suport, I can run an amarok2 DB with it? From a remote computer?

XavierP · 03-01-2009, 03:02 PM

By the looks of things, the embedded bit is required by Amarok2 specifically. So I would assume so since MySQL is still being used.

Dankles · 03-01-2009, 03:03 PM

Quote:

Originally Posted by XavierP

By the looks of things, the embedded bit is required by Amarok2 specifically. So I would assume so since MySQL is still being used.

Guess I'll just have to give it a go...
Thanks