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

[Dmitri Popov]

Sure thing! I'll ping you when the script is ready. Thanks, Gilles!

Best,
Dmitri
---
Tōkyō Made - https://tokyoma.de/

June 9, 2021 10:43 AM, "Gilles Caulier" <caulier.gilles at gmail.com> wrote:

> 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/