Simon Willison

Switch CI solution to GitHub Actions with a macOS runner

1

Refs #17.

Import machine-learning detected labels (dog, llama etc) from Apple Photos

13

Follow-on from #1. Apple Photos runs some very sophisticated machine learning on-device to figure out if photos are of dogs, llamas and so on. I really want to extract those...

Import photo metadata from Apple Photos into SQLite

8

Faces, albums, locations, that kind of thing.

Annotate photos using the Google Cloud Vision API

5

It can detect faces, run OCR, do image labeling (it knows what a lemur is!) and do object localization where it identifies objects and returns bounding polygons for them.

Also upload movie files

2

The `upload` command currently only handles static images: https://github.com/dogsheep/photos-to-sqlite/blob/d939455af00e07866686457ee2fcb9b2d1b7194e/photos_to_sqlite/utils.py#L26-L33 Need to cover movies taken by my phone and DSLR too.

If less than 500MB, show size in MB not GB

1

Just saw this: ``` Uploading 0.05 GB ```

Some workout columns should be float, not text

4

Columns `duration`, `totalDistance` and `totalEnergyBurned` should be converted to float. https://github.com/dogsheep/healthkit-to-sqlite/blob/71e36e1cf034b96de2a8e6652265d782d3fdf63b/healthkit_to_sqlite/utils.py#L50-L57

Add index on workout_points.date

2

Sorting that by date makes sense for seeing most recent points, and my DB has 2.5m points in so it's an expensive sort!

Documented examples for common denormalizations

3

I'm principally interested in using this library for denormalizations - thinks like: ```python class BlogEntry(Model) # ... num_comments = IntegerField() class Comment(Model): entry = ForeignKey(BlogEntry) # ... ``` Where that...

Adopt "Scripts to rule them all" pattern

1

https://github.com/github/scripts-to-rule-them-all I'll start with `script/bootstrap` and `script/server` and `script/build` and `script/update` scripts.