achrysos
Member
- Joined
- May 12, 2008
- Messages
- 47
- Location
- Cheshire, UK
- Lightroom Experience
- Advanced
- Lightroom Version
I'm sorry if this is the wrong discussion forum to post this question to, but it's the most appropriate one I could see.
I am trying to use some python and sql to extract different aspects of my LR catalogue. Does anybody know how I can extract the file size of the images in my database, and keep a track of how the file type of each image (I am able to extract the file types, e.g. dng, jpg, etc, and count them)? Basically, I already have a count of each image file type, I now want to determine the volume (GB) taken up by each file type.
I know that there are some gurus around that play with the LR database, so I'd appreciate any help or pointers.
I note that the metadata panel does display the file size. If this is not stored in the database, does LR then just extract the file size for each image from the filesystem? (my backup plan!)
Thank you,
Antonio
I am trying to use some python and sql to extract different aspects of my LR catalogue. Does anybody know how I can extract the file size of the images in my database, and keep a track of how the file type of each image (I am able to extract the file types, e.g. dng, jpg, etc, and count them)? Basically, I already have a count of each image file type, I now want to determine the volume (GB) taken up by each file type.
I know that there are some gurus around that play with the LR database, so I'd appreciate any help or pointers.
I note that the metadata panel does display the file size. If this is not stored in the database, does LR then just extract the file size for each image from the filesystem? (my backup plan!)
Thank you,
Antonio