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

[Dmitri Popov]

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/