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

[Dmitri Popov-4]

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/

[Gilles Caulier-4]

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/

[Dmitri Popov-4]

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/

... [show rest of quote]

[Gilles Caulier-4]

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/

... [show rest of quote]

[Dmitri Popov-4]

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/

... [show rest of quote]

[Gilles Caulier-4]

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 <[hidden email]> 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" <[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/

... [show rest of quote]

[Dmitri Popov-4]

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" <[hidden email]> 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 <[hidden email]> 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" <[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/

... [show rest of quote]

[Gilles Caulier-4]

yes,i know your nickname. Invitation was sent this morning already (:-)))

Gilles

Le mer. 9 juin 2021 à 13:23, Dmitri Popov <[hidden email]> a écrit :

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" <[hidden email]> 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 <[hidden email]> 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" <[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/

... [show rest of quote]

[Dmitri Popov-4]

Ah, the invite went to my work email address. I've accepted the invitation. Thanks, Gilles!

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

June 9, 2021 1:24 PM, "Gilles Caulier" <[hidden email]> wrote:

> yes,i know your nickname. Invitation was sent this morning already (:-)))
>
> Gilles
> Le mer. 9 juin 2021 à 13:23, Dmitri Popov <[hidden email]> a écrit :
>
>> 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" <[hidden email]> 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 <[hidden email]> 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" <[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/

... [show rest of quote]

[papertape]

Using Windows 7 Home Premium 64-bit

I downloaded  digikam-pgf-database/bin/pgfdatabase.exe
When I run it, a window flashes briefly, then nothing.

Did I miss something?


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



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[Gilles Caulier-4]

It's a command line tool, not a GUI. Run it from a Terminal.

Best

Gilles Caulier

Le dim. 20 juin 2021 à 09:30, papertape <[hidden email]> a écrit :

Using Windows 7 Home Premium 64-bit

I downloaded  digikam-pgf-database/bin/pgfdatabase.exe
When I run it, a window flashes briefly, then nothing.

Did I miss something?


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



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

... [show rest of quote]

[Remco Viëtor]

On dimanche 20 juin 2021 03:03:27 CEST papertape wrote:
> Using Windows 7 Home Premium 64-bit
>
> I downloaded  digikam-pgf-database/bin/pgfdatabase.exe
> When I run it, a window flashes briefly, then nothing.
From the README, I understand that
- it's a command line program
- that needs to get the pgf file to convert provided as a parameter
(so: you'd have to do something like
        #> pgfdatabase.exe my_pgf_blob
)

Just a double-click on the executable will execute it, so windows opens a
console, the program will show a short message on that console and shut down,
windows closes the (now unneeded) console window;  which you see as a window
flashing briefly.

To extract (all!) the pgf images from the database you need to use another
program (e.g. the export_thumbnails.sh shell script for linux)