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

[Dmitri Popov]

Hi Gilles,

> I invite you to contribute to the github project where is store the PGF to PNG converter.

That would be perfect! My GitHub username is dmpop

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

June 9, 2021 1:18 PM, "Gilles Caulier" <caulier.gilles at gmail.com> wrote:

> 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
> Le mer. 9 juin 2021 à 12:45, Dmitri Popov <dmpop at tokyoma.de> a écrit :
> 
>> 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/