Re: Extract thumbnails from thumbnails-digikam.db
Posted by
Gilles Caulier-4 on
Jun 09, 2021; 11:18am
URL: http://digikam.185.s1.nabble.com/digiKam-users-Extract-thumbnails-from-thumbnails-digikam-db-tp4717132p4717140.html
I invite you to contribute to the github project where is store the PGF to PNG converter. This is the right place to store extra scripts to extract PGF blob from database.
Best regards
Gilles
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" <[hidden email]> 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 <[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/