[digiKam-users] Face database

[Maik Qualmann]

Hi Gilles,

Good question, technical details like that might be too much for a user 
manual. Maybe it would be better to create a separate documentation for it.

Maik

Am Donnerstag, 16. März 2023, 13:09:05 CET schrieb Gilles Caulier:
> Hi Maik,
> 
> Perhaps it can be a good idea to host the databases structure to the
> online documentation. What do you think about ?
> 
> Gilles
> 
> Le jeu. 16 mars 2023 à 12:49, Maik Qualmann <metzpinguin at gmail.com> a écrit 
:
> > Look in the thumbnail database in the "CustomIdentifiers" table. You can't
> > just join it via SQL.
> > 
> > In the digiKam core database in the "ImageTagProperties" table you can
> > find the faces, unconfirmed, confirmed etc.
> > You can use the imageid to assemble the album path with the root path. The
> > rectangle coordinates of the face are in the "value" table. Then you can
> > build a "CustomIdentifiers" string to get the corresponding thumbid.
> > 
> > Maik
> > 
> > Am Donnerstag, 16. März 2023, 12:17:01 CET schrieb tomtom:
> > > Hello,
> > > I need to make join betewen  the attribute Id of the thumbnail and
> > > the image id corresponding.
> > > Witch table and witch attribut is it?
> > > I don't find it in the DBSCHEMA file.
> > > Thank's for all your answer
> > > 
> > > Gilles Caulier <caulier.gilles at gmail.com> a écrit :
> > > > Hi,
> > > > 
> > > > The database schema is described in libre office spreadsheet located
> > > > here
> > > > 
> > > > 
> > > > https://invent.kde.org/graphics/digikam/-/blob/master/project/document
> > > > s/DB
> > > > SCHEMA.ODS
> > > > 
> > > > Best
> > > > 
> > > > Gilles Caulier
> > > > 
> > > > Le jeu. 2 mars 2023 à 14:22, tomtom <tomtom at samizdat.net> a écrit :
> > > >> Hello
> > > >> I'm thomas
> > > >> I don't know if it's the rignt place to ask this very database
> > > >> oriented.
> > > >> If it's not, could someone tell me where I can ask.
> > > >> I want to extract face thumbnails.
> > > >> I need to make the difference between thumbnail image and  thumbnail
> > > >> face.
> > > >> I searche in the database of digikam witch table and witch  array I
> > > >> can use to find it.
> > > >> Witch primary or foreign key I can use to extract blob in the
> > > >> thumbnail data base.
> > > >> Thank's you for your time.