This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Sharing database between computes

Tags: None
(comma "," separated)
Horus
Registered Member
Posts
296
Karma
0
OS

Sharing database between computes

Sun May 18, 2014 1:01 pm
Hello,

I listen to music at home on my desktop with my music data in $home and at work on my laptop with my music data on an external drive.

What is the best way to not only share the music but also the Amarok database between these two machines?

Can I simply put ~/.kde4/share/apps/amarok (or just parts of this directory) on Dropbox and symlink it to its previous location on both machines? May be problematic if two instances of Amarok are active the same time. I think this can be resolved by starting Amarok using a script which creates a lockfile. If this directory is shared amarok probably expects the music files at the same collection two. So I would also be symlinking ~/Musik to /media/external/storage/ on my laptop. Any problems I'm missing here?

Any other ideas you have?

I know about syncing metadata using last.fm but rather prefer a more local approach.

Thanks!
User avatar
Mamarok
Manager
Posts
6071
Karma
16
OS
Not a good idea, you better in that case use an external MySQL database that both computers can access.


Running Kubuntu 22.10 with Plasma 5.26.3, Frameworks 5.100.0, Qt 5.15.6, kernel 5.19.0-23 on Ryzen 5 4600H, AMD Renoir, X11
FWIW: it's always useful to state the exact Plasma version (+ distribution) when asking questions, makes it easier to help ...
Horus
Registered Member
Posts
296
Karma
0
OS
Why not a good idea?

Using an external MySQL database afaik requires a permanent network connection to that server, something which is not given for my laptop and therefore not feasible.
peterbl
Registered Member
Posts
1
Karma
0
OS

Re: Sharing database between computes

Sat Jul 19, 2014 10:00 am
In order to share the database between computers, should the paths of the files be the same for every computer? Is there any other restriction, e.g. about the devices on which the files are stored etc?
User avatar
Mamarok
Manager
Posts
6071
Karma
16
OS

Re: Sharing database between computes

Sat Jul 19, 2014 11:09 am
Well, sharing a database means that you can access the database from other computers, but the path settings should be irrelevant, provided that both write to the database with the same rights.

What you can't do is distinguish the source of the tracks, as they will all just appear in the local collection. I assume you have tracks on different computers. And you will get warnings if you have duplicate tracks.


Running Kubuntu 22.10 with Plasma 5.26.3, Frameworks 5.100.0, Qt 5.15.6, kernel 5.19.0-23 on Ryzen 5 4600H, AMD Renoir, X11
FWIW: it's always useful to state the exact Plasma version (+ distribution) when asking questions, makes it easier to help ...


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot], Yahoo [Bot]