Login  Register

Re: Extract thumbnails from thumbnails-digikam.db

Posted by Gilles Caulier-4 on Jun 09, 2021; 8:43am
URL: http://digikam.185.s1.nabble.com/digiKam-users-Extract-thumbnails-from-thumbnails-digikam-db-tp4717132p4717138.html

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 <[hidden email]> a écrit :
Thank you very much for your prompt reply, Gilles!

Best,
Dmitri

June 8, 2021 6:36 PM, "Gilles Caulier" <[hidden email]> 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 <[hidden email]> 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/