Import EXIF data into SQLite - lens used, ISO, aperture etc

dogsheep / dogsheep-photos

Upload your photos to S3 and import metadata about them into a SQLite database

Apache License 2.0

170 stars 15 forks source link

Import EXIF data into SQLite - lens used, ISO, aperture etc #3

Open simonw opened 4 years ago

jratike80 commented 2 years ago

Maybe the exif-loader from the SpatiaLite project could be useful as a reference even it is written in C and it also saves images as blobs https://www.gaia-gis.it/fossil/spatialite-tools/file?name=exif_loader.c&ci=tip. The tool is also integrated into the spatialite-gui application.

I found some user documentation from the web archive http://web.archive.org/web/20180629041238/https://www.gaia-gis.it/spatialite-2.3.1/spatialite-exif-2.3.1.html.

RhetTbull commented 2 years ago

As dogsheep-photos already uses osxphotos to load photos you can access the EXIF data via osxphotos. Apple Photos imports a small subset of EXIF data at the time the photo is imported and osxphotos provides this via the exif_info property. If you want the full EXIF data, osxphotos also provides a wrapper around exiftool.