I back up my photos and digikam database to a low powered home server. I'm trying to make a small web viewer built on the backed up photos and database.
So I'm trying to figure out how the digikam4.db database is configured. I'm a little perplexed by the FilePaths table - it includes a lot of my images, but not all of them. Is it left over from an older Digikam version? Is there a newer place I should look for file paths? Is there a reference out there for the current database schema? I'm not really a developer, so I had trouble interpreting the developer resources website. Sorry for the torrent of questions.
Thanks
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
OK, I eventually figured out the answer to my own question after examing the tables more closely. The FilePaths table does appear to be outdated, and I was able to pull together what I need for the file paths with the query:
However, if there is any documentation out there explaining the layout of the database, please point me to it. Thanks!
On Mon, Dec 10, 2012 at 9:40 PM, [hidden email] <[hidden email]> wrote: I back up my photos and digikam database to a low powered home server. I'm trying to make a small web viewer built on the backed up photos and database. _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Hi,
A shot in the dark here but I think there is documentation for this included in the src. So download the code base and look in there. /Anders 2012/12/11 [hidden email] <[hidden email]>: > OK, I eventually figured out the answer to my own question after examing the > tables more closely. The FilePaths table does appear to be outdated, and I > was able to pull together what I need for the file paths with the query: > > SELECT i.name, a.relativePath FROM Albums a, Images i WHERE i.album = a.id > > However, if there is any documentation out there explaining the layout of > the database, please point me to it. Thanks! > > > > On Mon, Dec 10, 2012 at 9:40 PM, [hidden email] > <[hidden email]> wrote: >> >> I back up my photos and digikam database to a low powered home server. I'm >> trying to make a small web viewer built on the backed up photos and >> database. >> >> So I'm trying to figure out how the digikam4.db database is configured. >> I'm a little perplexed by the FilePaths table - it includes a lot of my >> images, but not all of them. Is it left over from an older Digikam version? >> Is there a newer place I should look for file paths? Is there a reference >> out there for the current database schema? I'm not really a developer, so I >> had trouble interpreting the developer resources website. Sorry for the >> torrent of questions. >> >> Thanks > > > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Free forum by Nabble | Edit this page |