Side note, been a while sense i looked, is there a sqlite db for the contacts table?

Yes

well the created_at/updated_at (these arnt the names of the colums, but still) are from when my macbook synced and not when the actual contact was created. useful, but not what i needed.

Looks promising - will look into it!

So it appears you can conveniently query the DB for filename (+directory), UUID, and (original) file size. But I can't find a good way of opening a Photo by filename or UUID.

After all, the file might not be present locally, so opening it should go through the Photos.app. But once you call AppleScript to open the file, you might as well use the AppleScript to comb through the database like the script I linked to earlier.

Check out this which I believe has that feature: https://github.com/RhetTbull/osxphotos

Yes, `osxphotos show UUID` will open the photo with UUID in the Photos app. (I'm the author of osxphotos)

>write since code

"since" -> "some". ugh. I had a bad swiping day apparently.