[digiKam-users] Extract thumbnails from thumbnails-digikam.db

Gilles Caulier caulier.gilles at gmail.com
Wed Jun 9 09:43:38 BST 2021


Hi Dmitri,

If you have a script to extract thumbnails as PGF blobs from digiKam
database, we can share files in my github project.

Best

Gilles

Le mer. 9 juin 2021 à 09:00, Dmitri Popov <dmpop at tokyoma.de> a écrit :

> Thank you very much for your prompt reply, Gilles!
>
> Best,
> Dmitri
>
> June 8, 2021 6:36 PM, "Gilles Caulier" <caulier.gilles at gmail.com> wrote:
>
> > hi Dmitri,
> >
> > Hey no, it's not a JPEG image, it's PGF image image (using wavelets
> compression). It's better than
> > JPEG in speed, quality, and size.
> >
> > To convert this PGF t PNG for ex, use my CLI tool from my github account
> :
> >
> > https://github.com/cgilles/digikam-pgf-database
> >
> > Best regards
> >
> > Gilles Caulier
> > Le mar. 8 juin 2021 à 18:20, Dmitri Popov <dmpop at tokyoma.de> a écrit :
> >
> >> Hello,
> >>
> >> A technical question from someone who has no idea what he's doing. :-)
> I'm trying to exact a
> >> thumbnail directly from the thumbnails-digikam.db database, but this
> command gives me a file that
> >> is not recognized as JPEG:
> >>
> >> sqlite thumbnails-digikam.db "SELECT writefile('thumbnail.jpg', data)
> FROM Thumbnails WHERE id=1;"
> >>
> >> What am I doing wrong?
> >>
> >> Thank you!
> >>
> >> Kind regards,
> >> Dmitri
> >> ---
> >> Tōkyō Made - https://tokyoma.de/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20210609/c1a9f904/attachment.htm>


More information about the Digikam-users mailing list