[digiKam-users] New to DK - questions.
Locked
 
|
Greetings! I am really looking forward to getting more familiar with
digiKam! I may have been too enthusiastic starting out. I read the article "Use digiKam with a NAS and MariaDB" and then installed the windows version and a linux version, and put a MariaDB on my freenas. All went well after a short learning curve. I do still have a few questions I could not find in past posts or the FAQ. Perhaps this is obvious, but where are the images stored? Does the DB just store thumbnails, metadata and pointers to images? If so how can I use both linux and windows since the pointers stored in the DB will be different even if they point to the NAS which both machine can see, but with a slightly different paths? In any case I am sure it will be pretty important to update digiKam on each platform at the same time. Until I get this figured out I'm only using linux to add photos. Thanks! Kip |
|
|
Hello,
You are correct on what digiKam DB is. You would need to add your images as Collections in Settings. I am not sure if there is way to use the same database from both linux and windows though because paths to images will be different. The only way I see is to write to sidecar files. But maybe someone else in this room already figured that out? Thanks, Andrey -----Original Message----- From: Digikam-users <[hidden email]> On Behalf Of Cleaneasy Sent: March 19, 2019 9:00 PM To: [hidden email] Subject: [digiKam-users] New to DK - questions. Greetings! I am really looking forward to getting more familiar with digiKam! I may have been too enthusiastic starting out. I read the article "Use digiKam with a NAS and MariaDB" and then installed the windows version and a linux version, and put a MariaDB on my freenas. All went well after a short learning curve. I do still have a few questions I could not find in past posts or the FAQ. Perhaps this is obvious, but where are the images stored? Does the DB just store thumbnails, metadata and pointers to images? If so how can I use both linux and windows since the pointers stored in the DB will be different even if they point to the NAS which both machine can see, but with a slightly different paths? In any case I am sure it will be pretty important to update digiKam on each platform at the same time. Until I get this figured out I'm only using linux to add photos. Thanks! Kip |
|
|
Hi all, There are some problematics to share the same databases between Linux and Windows through the network : 1/ the concurrent access can break the database. There is no lock mechanism in digiKam to prevent this kind of problem. 2/ the string encoding are not the same : Linux=UTF8, Windows=!UTF8. 3/ the file path are completely differents. 4/ the UUID computed to identify the collection mount path can be different (code from KF5::Solid are not the same : I'm not sure) There are plenty of bug reports in bugzilla about this topic. The problem is know. Best Gilles Caulier Le mer. 20 mars 2019 à 04:13, Andrey Goreev <[hidden email]> a écrit : Hello, |
|
|
In reply to this post by AndriusWild
Yes there is a way to use the same db from different OSes. See
https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was added to let you specify multiple paths in albumroot so each system can have its own version at the same time. However there is STILL no UI to do this and everyone keeps forgetting about it and it is not mentioned anywhere! Also IMHO a better plan would be to move the albumroot setting into the rc file (which is local to each system), but that suggestion is simply ignored by the developers. Getting this sorted properly would be a major step forward in the usability of digikam. Andrew On 20/03/2019 03:11, Andrey Goreev wrote: > Hello, > > You are correct on what digiKam DB is. > You would need to add your images as Collections in Settings. > I am not sure if there is way to use the same database from both linux and > windows though because paths to images will be different. > The only way I see is to write to sidecar files. > But maybe someone else in this room already figured that out? > > Thanks, > Andrey > > -----Original Message----- > From: Digikam-users <[hidden email]> On Behalf Of Cleaneasy > Sent: March 19, 2019 9:00 PM > To: [hidden email] > Subject: [digiKam-users] New to DK - questions. > > Greetings! I am really looking forward to getting more familiar with > digiKam! > > I may have been too enthusiastic starting out. I read the article "Use > digiKam with a NAS and MariaDB" and then installed the windows version and a > linux version, and put a MariaDB on my freenas. All went well after a short > learning curve. I do still have a few questions I could not find in past > posts or the FAQ. > > Perhaps this is obvious, but where are the images stored? Does the DB just > store thumbnails, metadata and pointers to images? If so how can I use both > linux and windows since the pointers stored in the DB will be different even > if they point to the NAS which both machine can see, but with a slightly > different paths? > > In any case I am sure it will be pretty important to update digiKam on each > platform at the same time. Until I get this figured out I'm only using linux > to add photos. > > Thanks! > Kip > > > |
|
|
Le mer. 20 mars 2019 à 09:53, Andrew Goodbody <[hidden email]> a écrit : Yes there is a way to use the same db from different OSes. See It's not ignored, just delayed. 6.0.0 has take age to be finalized. 6.1.0 introduce new dplugins interface which is huge change in API and the goal to stabilize code for the future is now done. Currently i work since 3 weeks about to upgrade all bundles from Qt 5.9 to Qt 5.11, and the side effects are enormous. I see the light anyway. We will to be focused on database interoperability while this year. Gilles Caulier |
|
|
In reply to this post by Andrew Goodbody
On mercredi 20 mars 2019 09:52:44 CET Andrew Goodbody wrote:
> Yes there is a way to use the same db from different OSes. See > https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was added to > let you specify multiple paths in albumroot so each system can have its > own version at the same time. However there is STILL no UI to do this > and everyone keeps forgetting about it and it is not mentioned anywhere! > > Also IMHO a better plan would be to move the albumroot setting into the > rc file (which is local to each system), but that suggestion is simply > ignored by the developers. > > Getting this sorted properly would be a major step forward in the > usability of digikam. > step. But when you have a remote (networked) collection, there's a very good chance that it will be accessed from different terminals (and not just through different OSes). And *that* means you'll get concurrent access sooner or later. From what I gathered here, concurrent access to the database is *not* supported yet. Result: sooner or later you will get database corruption. With all the headaches that causes. So, until that kind of issues are dealt with, it might not be the best of ideas to make multi-system access too easy (and noting the caveats in the configuration dialog isn't enough, in practice). Remco |
|
|
In reply to this post by Andrew Goodbody
Andrew, As bug 261277 is now closed, i recommend to open a new file with the explicit whish to store the Mount path on rc file to improve the interoperabilty. Best Gilles Caulier Le mer. 20 mars 2019 à 09:53, Andrew Goodbody <[hidden email]> a écrit : Yes there is a way to use the same db from different OSes. See |
|
|
In reply to this post by Remco Viëtor
The AlbumRoot can not be moved to an RC file. It is part of the SQL query. We already have a patch for multiple AlbumRoots, I'll write more tonight. Maik Remco Viëtor <[hidden email]> schrieb am Mi., 20. März 2019 10:39: On mercredi 20 mars 2019 09:52:44 CET Andrew Goodbody wrote: |
|
|
In reply to this post by Remco Viëtor
On Wed, Mar 20, 2019 at 5:39 PM Remco Viëtor <[hidden email]> wrote:
Couldn't, in a first phase, the first instance of DK that accesses the DB just lock the DB. Other instances would then emit a message "waiting for other instances to release the DB" until the first user closes his DK instance. That would be a quick fix to your issue and at least allow the same user to access the DB across different OSes. Phase 2, only set the lock when an actual DB access occurs. Then you're getting very close to concurrent access without corruption. Hajo |
|
|
In reply to this post by Andrew Goodbody
Thanks Andrew. Wow, this solution dates back to 2011! I will have a closer look.
There does still seem to be the issue of string encoding - an OS saying that the old locale is "utf-8" and the new locale is "system". I've tested a little and once you commit to one on an OS the other OS will ask if you want to change it back. I am not sure how concerned I should be about this. I don't want to test this myself so I'll stick to adding images from the same machine for now. I'm comfortable knowing that transactions have not been implemented and concurrent access could cause problems. My setup is just for home, so concurrent access will not be a problem. I can understand not making multi-albumroot a GUI option at this time. It's good to hear more DB work is coming - I assume bundling SQL statements using TCL is the bulk of the work. UUID can be different but if both UUIDs have access there should be no issues (guessing - I have not seen the code.) I can see how partial access by one UUID could cause problems - I'll check to make sure they both have full rights. Also I don't understand the problem with keeping the albumroot local to the machine (RC file). It just seems right, but I know developers have the long view. Kip -----Original Message----- From: Digikam-users <[hidden email]> On Behalf Of Andrew Goodbody Sent: Wednesday, March 20, 2019 3:53 AM To: [hidden email] Subject: Re: [digiKam-users] New to DK - questions. Yes there is a way to use the same db from different OSes. See https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was added to let you specify multiple paths in albumroot so each system can have its own version at the same time. However there is STILL no UI to do this and everyone keeps forgetting about it and it is not mentioned anywhere! Also IMHO a better plan would be to move the albumroot setting into the rc file (which is local to each system), but that suggestion is simply ignored by the developers. Getting this sorted properly would be a major step forward in the usability of digikam. Andrew On 20/03/2019 03:11, Andrey Goreev wrote: > Hello, > > You are correct on what digiKam DB is. > You would need to add your images as Collections in Settings. > I am not sure if there is way to use the same database from both linux > and windows though because paths to images will be different. > The only way I see is to write to sidecar files. > But maybe someone else in this room already figured that out? > > Thanks, > Andrey > > -----Original Message----- > From: Digikam-users <[hidden email]> On Behalf Of > Cleaneasy > Sent: March 19, 2019 9:00 PM > To: [hidden email] > Subject: [digiKam-users] New to DK - questions. > > Greetings! I am really looking forward to getting more familiar with > digiKam! > > I may have been too enthusiastic starting out. I read the article "Use > digiKam with a NAS and MariaDB" and then installed the windows version > and a linux version, and put a MariaDB on my freenas. All went well > after a short learning curve. I do still have a few questions I could > not find in past posts or the FAQ. > > Perhaps this is obvious, but where are the images stored? Does the DB > just store thumbnails, metadata and pointers to images? If so how can > I use both linux and windows since the pointers stored in the DB will > be different even if they point to the NAS which both machine can see, > but with a slightly different paths? > > In any case I am sure it will be pretty important to update digiKam on > each platform at the same time. Until I get this figured out I'm only > using linux to add photos. > > Thanks! > Kip > > > |
|
|
In reply to this post by Andrew Goodbody
Could I use a UNC for my albumroot (mountpath) rather than mounting it to a drive letter? (ex. \\FREENAS\media\AllPics )
The example I was using from bugs.kde.org is: "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" This test works: QUrl url; url.setScheme("networkshareid"); url.addQueryItem("mountpath", "/mnt/test1"); url.addQueryItem("mountpath", "/mnt/test2"); QByteArray urlString = url.toEncoded(); QUrl url2 = QUrl::fromEncoded(urlString); qDebug() << url2.toEncoded() << url.toString(); qDebug() << url2.allQueryItemValues("mountpath"); Output "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" ("/mnt/test1", "/mnt/test2") -----Original Message----- From: Digikam-users <[hidden email]> On Behalf Of Andrew Goodbody Sent: Wednesday, March 20, 2019 3:53 AM To: [hidden email] Subject: Re: [digiKam-users] New to DK - questions. Yes there is a way to use the same db from different OSes. See https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was added to let you specify multiple paths in albumroot so each system can have its own version at the same time. However there is STILL no UI to do this and everyone keeps forgetting about it and it is not mentioned anywhere! Also IMHO a better plan would be to move the albumroot setting into the rc file (which is local to each system), but that suggestion is simply ignored by the developers. Getting this sorted properly would be a major step forward in the usability of digikam. Andrew On 20/03/2019 03:11, Andrey Goreev wrote: > Hello, > > You are correct on what digiKam DB is. > You would need to add your images as Collections in Settings. > I am not sure if there is way to use the same database from both linux > and windows though because paths to images will be different. > The only way I see is to write to sidecar files. > But maybe someone else in this room already figured that out? > > Thanks, > Andrey > > -----Original Message----- > From: Digikam-users <[hidden email]> On Behalf Of > Cleaneasy > Sent: March 19, 2019 9:00 PM > To: [hidden email] > Subject: [digiKam-users] New to DK - questions. > > Greetings! I am really looking forward to getting more familiar with > digiKam! > > I may have been too enthusiastic starting out. I read the article "Use > digiKam with a NAS and MariaDB" and then installed the windows version > and a linux version, and put a MariaDB on my freenas. All went well > after a short learning curve. I do still have a few questions I could > not find in past posts or the FAQ. > > Perhaps this is obvious, but where are the images stored? Does the DB > just store thumbnails, metadata and pointers to images? If so how can > I use both linux and windows since the pointers stored in the DB will > be different even if they point to the NAS which both machine can see, > but with a slightly different paths? > > In any case I am sure it will be pretty important to update digiKam on > each platform at the same time. Until I get this figured out I'm only > using linux to add photos. > > Thanks! > Kip > > > |
|
|
Here we have a patch (https://bugs.kde.org/show_bug.cgi?id=384820) for a
different album root with different operating systems. However, I want to complete the patch so that each digiKam instance can set its own album root. Maik Am Donnerstag, 21. März 2019, 04:26:36 CET schrieb Cleaneasy: > Could I use a UNC for my albumroot (mountpath) rather than mounting it to a > drive letter? (ex. \\FREENAS\media\AllPics ) > > The example I was using from bugs.kde.org is: > > > "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" > > This test works: > > QUrl url; > url.setScheme("networkshareid"); > url.addQueryItem("mountpath", "/mnt/test1"); > url.addQueryItem("mountpath", "/mnt/test2"); > QByteArray urlString = url.toEncoded(); > QUrl url2 = QUrl::fromEncoded(urlString); > qDebug() << url2.toEncoded() > << url.toString(); > qDebug() << url2.allQueryItemValues("mountpath"); > > Output > > "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" > "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" ("/mnt/test1", > "/mnt/test2") > > > > > > -----Original Message----- > From: Digikam-users <[hidden email]> On Behalf Of Andrew > Goodbody Sent: Wednesday, March 20, 2019 3:53 AM > To: [hidden email] > Subject: Re: [digiKam-users] New to DK - questions. > > Yes there is a way to use the same db from different OSes. See > https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was added to let > you specify multiple paths in albumroot so each system can have its own > version at the same time. However there is STILL no UI to do this and > everyone keeps forgetting about it and it is not mentioned anywhere! > > Also IMHO a better plan would be to move the albumroot setting into the rc > file (which is local to each system), but that suggestion is simply ignored > by the developers. > > Getting this sorted properly would be a major step forward in the usability > of digikam. > > Andrew > > On 20/03/2019 03:11, Andrey Goreev wrote: > > Hello, > > > > You are correct on what digiKam DB is. > > You would need to add your images as Collections in Settings. > > I am not sure if there is way to use the same database from both linux > > and windows though because paths to images will be different. > > The only way I see is to write to sidecar files. > > But maybe someone else in this room already figured that out? > > > > Thanks, > > Andrey > > > > -----Original Message----- > > From: Digikam-users <[hidden email]> On Behalf Of > > Cleaneasy > > Sent: March 19, 2019 9:00 PM > > To: [hidden email] > > Subject: [digiKam-users] New to DK - questions. > > > > Greetings! I am really looking forward to getting more familiar with > > digiKam! > > > > I may have been too enthusiastic starting out. I read the article "Use > > digiKam with a NAS and MariaDB" and then installed the windows version > > and a linux version, and put a MariaDB on my freenas. All went well > > after a short learning curve. I do still have a few questions I could > > not find in past posts or the FAQ. > > > > Perhaps this is obvious, but where are the images stored? Does the DB > > just store thumbnails, metadata and pointers to images? If so how can > > I use both linux and windows since the pointers stored in the DB will > > be different even if they point to the NAS which both machine can see, > > but with a slightly different paths? > > > > In any case I am sure it will be pretty important to update digiKam on > > each platform at the same time. Until I get this figured out I'm only > > using linux to add photos. > > > > Thanks! > > Kip |
|
|
Maik, This kind of patch will touch certainly a core changes and it must preferable to introduce it in a main release as 7.0.0. Right ? Gilles Le jeu. 21 mars 2019 à 08:00, Maik Qualmann <[hidden email]> a écrit : Here we have a patch (https://bugs.kde.org/show_bug.cgi?id=384820) for a |
|
|
In reply to this post by Gilles Caulier-4
On 20/03/2019 09:27, Gilles Caulier wrote:
> Le mer. 20 mars 2019 à 09:53, Andrew Goodbody <[hidden email] > <mailto:[hidden email]>> a écrit : > > Yes there is a way to use the same db from different OSes. See > https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was added to > let you specify multiple paths in albumroot so each system can have its > own version at the same time. However there is STILL no UI to do this > and everyone keeps forgetting about it and it is not mentioned anywhere! > > Also IMHO a better plan would be to move the albumroot setting into the > rc file (which is local to each system), but that suggestion is simply > ignored by the developers. > > It's not ignored, just delayed. 6.0.0 has take age to be finalized. I was just saying that in all the years I have been suggesting this, never once has any developer publicly acknowledged the suggestion let alone commented on it. You do a great job and everything takes time. This was in no way a complaint about timescales. I fully appreciate the time taken to make sure a release is done right. > 6.1.0 introduce new dplugins interface which is huge change in API and > the goal to stabilize code for the future is now done. This is a great basis for further development. Your efforts will certainly mean that digikam can continue to grow in a sustainable way. > Currently i work since 3 weeks about to upgrade all bundles from Qt 5.9 > to Qt 5.11, and the side effects are enormous. I see the light anyway. Sounds like a big job and none the more pleasant for being imposed on you by external changes. > We will to be focused on database interoperability while this year. > > Gilles Caulier That will be wonderful to see the fruits of in the future. I am sorry if I seemed a bit grumpy in my email. I think that all the developers do an amazing job spending huge amounts of their time for the benefit of many others. I do not say this often enough, but thank you. I am very grateful for all your efforts. Andrew |
|
|
In reply to this post by Gilles Caulier-4
It has been 6 months since this was talked about and there is now
planning for 7.0.0 under way so I just thought I would send a small ping about it. Thanks, Andrew On 21/03/2019 08:37, Gilles Caulier wrote: > Maik, > > This kind of patch will touch certainly a core changes and it must > preferable to introduce it in a main release as 7.0.0. Right ? > > Gilles > > Le jeu. 21 mars 2019 à 08:00, Maik Qualmann <[hidden email] > <mailto:[hidden email]>> a écrit : > > Here we have a patch (https://bugs.kde.org/show_bug.cgi?id=384820) > for a > different album root with different operating systems. However, I > want to > complete the patch so that each digiKam instance can set its own > album root. > > Maik > > Am Donnerstag, 21. März 2019, 04:26:36 CET schrieb Cleaneasy: > > Could I use a UNC for my albumroot (mountpath) rather than > mounting it to a > > drive letter? (ex. \\FREENAS\media\AllPics ) > > > > The example I was using from bugs.kde.org <http://bugs.kde.org> is: > > > > > > "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" > > > > This test works: > > > > QUrl url; > > url.setScheme("networkshareid"); > > url.addQueryItem("mountpath", "/mnt/test1"); > > url.addQueryItem("mountpath", "/mnt/test2"); > > QByteArray urlString = url.toEncoded(); > > QUrl url2 = QUrl::fromEncoded(urlString); > > qDebug() << url2.toEncoded() > > << url.toString(); > > qDebug() << url2.allQueryItemValues("mountpath"); > > > > Output > > > > "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" > > "networkshareid:?mountpath=/mnt/test1&mountpath=/mnt/test2" > ("/mnt/test1", > > "/mnt/test2") > > > > > > > > > > > > -----Original Message----- > > From: Digikam-users <[hidden email] > <mailto:[hidden email]>> On Behalf Of Andrew > > Goodbody Sent: Wednesday, March 20, 2019 3:53 AM > > To: [hidden email] <mailto:[hidden email]> > > Subject: Re: [digiKam-users] New to DK - questions. > > > > Yes there is a way to use the same db from different OSes. See > > https://bugs.kde.org/show_bug.cgi?id=261277 where a patch was > added to let > > you specify multiple paths in albumroot so each system can have > its own > > version at the same time. However there is STILL no UI to do this and > > everyone keeps forgetting about it and it is not mentioned anywhere! > > > > Also IMHO a better plan would be to move the albumroot setting > into the rc > > file (which is local to each system), but that suggestion is > simply ignored > > by the developers. > > > > Getting this sorted properly would be a major step forward in the > usability > > of digikam. > > > > Andrew > > > > On 20/03/2019 03:11, Andrey Goreev wrote: > > > Hello, > > > > > > You are correct on what digiKam DB is. > > > You would need to add your images as Collections in Settings. > > > I am not sure if there is way to use the same database from > both linux > > > and windows though because paths to images will be different. > > > The only way I see is to write to sidecar files. > > > But maybe someone else in this room already figured that out? > > > > > > Thanks, > > > Andrey > > > > > > -----Original Message----- > > > From: Digikam-users <[hidden email] > <mailto:[hidden email]>> On Behalf Of > > > Cleaneasy > > > Sent: March 19, 2019 9:00 PM > > > To: [hidden email] <mailto:[hidden email]> > > > Subject: [digiKam-users] New to DK - questions. > > > > > > Greetings! I am really looking forward to getting more > familiar with > > > digiKam! > > > > > > I may have been too enthusiastic starting out. I read the > article "Use > > > digiKam with a NAS and MariaDB" and then installed the windows > version > > > and a linux version, and put a MariaDB on my freenas. All went > well > > > after a short learning curve. I do still have a few questions > I could > > > not find in past posts or the FAQ. > > > > > > Perhaps this is obvious, but where are the images stored? Does > the DB > > > just store thumbnails, metadata and pointers to images? If so > how can > > > I use both linux and windows since the pointers stored in the > DB will > > > be different even if they point to the NAS which both machine > can see, > > > but with a slightly different paths? > > > > > > In any case I am sure it will be pretty important to update > digiKam on > > > each platform at the same time. Until I get this figured out > I'm only > > > using linux to add photos. > > > > > > Thanks! > > > Kip > > > > |
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |