digiKam › digikam-users

Difference between Tags in Database (mysql) and Digikam

Classic

List

Threaded

4 messages Options

Frank Hommes

Difference between Tags in Database (mysql) and Digikam

Hi,

I'm giving out the tags in a php-script to show how many pictures have a
specific tag.
But there is a huge difference between the amount in the database
(18.000) and what Digikam (10.000) shows.

The database also shows 4 times the number of actual pictures in the
table Images. When I don't count the pictures which are two times in
there (why is this so?) it's still two times the actual pictures.

I got 100.000 actual pictures in the database, the table Images has
400.000 entries. A good indicator is the table Thumbnails... :)

Why are there such big differences and where does Digikam gets the real
numbers from?

Frank
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Gilles Caulier-4

Re: Difference between Tags in Database (mysql) and Digikam

Do you take a look in database schema used by digiKam ? file is there :

http://www.digikam.org/drupal/docs

Gilles Caulier

2010/7/5 Frank Hommes <[hidden email]>:

> Hi,
>
> I'm giving out the tags in a php-script to show how many pictures have a
> specific tag.
> But there is a huge difference between the amount in the database
> (18.000) and what Digikam (10.000) shows.
>
> The database also shows 4 times the number of actual pictures in the
> table Images. When I don't count the pictures which are two times in
> there (why is this so?) it's still two times the actual pictures.
>
> I got 100.000 actual pictures in the database, the table Images has
> 400.000 entries. A good indicator is the table Thumbnails... :)
>
> Why are there such big differences and where does Digikam gets the real
> numbers from?
>
> Frank
> _______________________________________________
> 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

Frank Hommes

Re: Difference between Tags in Database (mysql) and Digikam

Problem is that I've got 300.000 images with no Albumlink (NULL).
Some of those images have information which are lost for digikam at the
moment (https://bugs.kde.org/show_bug.cgi?id=243747).

I guess this problem occurs when you move pictures with the filemanager
and the comment has not been saved yet.

And thanks for the database shema! That will help me a lot anyway :)

Frank

On 07/06/2010 01:16 PM, Gilles Caulier wrote:

> Do you take a look in database schema used by digiKam ? file is there :
>
> http://www.digikam.org/drupal/docs
>
> Gilles Caulier
>
> 2010/7/5 Frank Hommes<[hidden email]>:
>> Hi,
>>
>> I'm giving out the tags in a php-script to show how many pictures have a
>> specific tag.
>> But there is a huge difference between the amount in the database
>> (18.000) and what Digikam (10.000) shows.
>>
>> The database also shows 4 times the number of actual pictures in the
>> table Images. When I don't count the pictures which are two times in
>> there (why is this so?) it's still two times the actual pictures.
>>
>> I got 100.000 actual pictures in the database, the table Images has
>> 400.000 entries. A good indicator is the table Thumbnails... :)
>>
>> Why are there such big differences and where does Digikam gets the real
>> numbers from?
>>
>> Frank
>> _______________________________________________
>> 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
>

--
Frank Hommes, Bummelberg 37, 44149 Dortmund, Germany
Email: [hidden email], ICQ: 14621277
Homepage: http://www.freanki.net
PGP-Key: http://www.freanki.net/gpg/
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Frank Hommes

Re: Difference between Tags in Database (mysql) and Digikam

In reply to this post by Gilles Caulier-4

The database schema is not complete. On Images - Table ImageComment -
The comment is written to the file (to the exif user comment, the Iptc
Caption and xmp Description). The database schema says nothing.

Frank

On 07/06/2010 01:16 PM, Gilles Caulier wrote: