Database FilePaths

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Database FilePaths

asourdiffe+list@gmail.com
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
Reply | Threaded
Open this post in threaded view
|

Re: Database FilePaths

asourdiffe+list@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, [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
Reply | Threaded
Open this post in threaded view
|

Re: 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 [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