[Digikam-users] Database FilePaths

[asourdiffe+list at gmail.com]

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, asourdiffe+list at gmail.com <
asourdiffe+list at gmail.com> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20121211/a8f16eb0/attachment.html>