[Digikam-users] Database FilePaths

[Anders Stedtlund]

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 asourdiffe+list at gmail.com <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
>
>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>