[digiKam-users] Extract thumbnails from thumbnails-digikam.db
Locked
[digiKam-users] Extract thumbnails from thumbnails-digikam.db
 
|
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/ |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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 : Best regards Gilles Caulier Le mar. 8 juin 2021 à 18:20, Dmitri Popov <[hidden email]> a écrit : Hello, |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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/ |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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! |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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/ |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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! |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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/ |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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, |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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/ |
|
|
In reply to this post by Dmitri Popov-4
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 |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
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 |
Re: Extract thumbnails from thumbnails-digikam.db
|
|
In reply to this post by papertape
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) |
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |