Using digikam on multiple computers

I’m a very happy digikam user. I had some issues a while back with very slow updates/refreshes of the database. With help from this forum I solved that by moving the database off my external hard drive and onto my laptop’s internal storage.

That’s been great! But, now I can only sort my photos on my laptop. I’m at work, and have my photos with me on the external hard drive, but without my digikam database I have to search through them by hand.

Is there a good way to get around this issue? The obvious answer is to move the db back to my external hard drive, but that makes the program nearly unusable with the frequent ‘hangs’ while I wait for the database to catch up.

What I do when I want to work on my laptop instead of my PC (I have a copy of my images on a SSD):

  1. use SQLite as database
  2. replace the databases from the digikam installation on your laptop with those from your pc
  3. open digikam4.db in DB Browser for SQLite on your laptop
  4. run a script with following commands
    update AlbumRoots set identifier=“volumeid:?uuid=e44f-854f” where id=1;
    update AlbumRoots set specificPath=“/home/kurts/Bilder” where id=1;

You should enter appropriate values for identifier and specificPath :wink:
Don’t know if you need the second command, take it as an example for other parameters.

Works without problems.

1 Like

I have my photos, digikam database & darktable synced between devices using Synology Drive.

Both machines have their data sync to identical username and path structure.

I’m very non technical.

Could you help me with the final hurdle.

I don’t know how to run step 4!

many thanks


ve got Sqlite open and can see the

Make a backup of the db! :smiley:

Open tab ‘Execute SQL’ and paste the lines into "SQL 1*':

Replace volumeid and specificPath with the correct values and replace the quotationmarks if you compied the lines from this side with those from your keyboard; they look similar, but are different characters and will lead to an error! Click on the left blue triangle to run the script.

Then, click on “Write Changes” - only with this the data will be written into the db.

1 Like

Thank you for your reply.
I will try that.

While I was waiting for a response, I changed the local path of my two synced collections using the preferences in DK. Which worked.

Given that it was a few clicks, perhaps I should continue doing that?

I’m experimenting with DK, to sync face tag into Darktable, which is great - although I can’t get DT to recognise Star rating changes or labels made in DK.

Always learning!