photos-to-sqlite

Save details of your photos to a SQLite database and upload them to S3

Installation

$ pip install photos-to-sqlite

Authentication

Create S3 credentials. This is a huge pain.

Run this command and paste in your credentials:

$ photos-to-sqlite s3-auth

This will create a file called auth.json in your current directory containing the required values. To save the file at a different path or filename, use the --auth=myauth.json option.

Uploading photos

Run this command to upload every photo in a specific directory to your S3 bucket:

$ photos-to-sqlite upload photos.db ~/Desktop

The command will only upload photos that have not yet been uploaded, based on their sha256 hash.

To see what the command would do without uploading any files, use the --dry-run option.

Importing Apple Photos metadata

The apple-photos command can be run after the upload command to import metadata from your Apple Photos library.

$ photo-to-sqlite apple-photos photos.db

Imported metadata includes places, people, albums, quality scores and machine learning labels for the photo contents.