Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Using SQL to find my best photo of a pelican according to Apple Photos

simonwillison.net

Post reply on HN
Print view View original

11–20 of 38 posts

Re: Using SQL to find my best photo of a pelican according to Apple Photos

#11

Post by simonw »

renewiltord wrote: post #3

This is incredible! Thank you for sharing! I sync my Google Photos and Apple Photos and I hope they both also run the model on things I've uploaded from a different device. Wish the Google stuff was also queriable like this.

Originally my plan was to upload everything to Google Photos and then export the metadata out via their API into a SQLite database so I could query it.

Google Photos does not have a comprehensive API - and more importantly they refuse to release geolocation information through it, which killed that option entirely for me. https://issuetracker.google.com/issues/80379228

Re: Using SQL to find my best photo of a pelican according to Apple Photos

#13

Post by ping_pong »

sp332 wrote: post #6
ping_pong wrote: post #5

I didn't realize that you could search for things on Apple Photos. That's the main reason why I use Google Photos, because its search capabilities are amazing. When I search for "chicken" it returns both fried chicken, raw chicken and actual chickens. I'll have to check The thing I don't like about Apple Photos is that when you sync with your Apple TV 4K, you can't actually play 4K 60 fps videos on your TV. I don't k…

Lots of details about Apple TV 4k video playback at https://www.theverge.com/2017/9/21/16341876/new-apple-tv-4k-...

Thanks. I just read the article and it's interesting but I think it's old. I do believe that you can match the frame rate with the original source in AppleTV now, and it also supports Dolby Atmos. Unfortunately my Sonos doesn't which is a real bummer.

The biggest issue for me is that I can upload a 4K video at 60 fps on Photos but it comes out terribly, with stuttering and looks terrible. It defeats the purpose of using 4K60 on the iPhone is you can't actually view it on a TV.

Re: Using SQL to find my best photo of a pelican according to Apple Photos

#14

Post by giancarlostoro »

hadrien01 wrote: post #7
ping_pong wrote: post #5

I didn't realize that you could search for things on Apple Photos. That's the main reason why I use Google Photos, because its search capabilities are amazing. When I search for "chicken" it returns both fried chicken, raw chicken and actual chickens. I'll have to check The thing I don't like about Apple Photos is that when you sync with your Apple TV 4K, you can't actually play 4K 60 fps videos on your TV. I don't k…

The Photos app in Windows 10 has the same capability. And the Apple and Microsoft apps are totally offline, unlike Google Photos.

Is the Windows 10 one truly offline or does it eventually phone home in some way? Genuinely asking out of curiosity.

Re: Using SQL to find my best photo of a pelican according to Apple Photos

#15

Post by [deleted] »

giancarlostoro wrote: post #14
hadrien01 wrote: post #7

Earlier quoted context omitted.

The Photos app in Windows 10 has the same capability. And the Apple and Microsoft apps are totally offline, unlike Google Photos.

Is the Windows 10 one truly offline or does it eventually phone home in some way? Genuinely asking out of curiosity.

[deleted]

Re: Using SQL to find my best photo of a pelican according to Apple Photos

#17

Post by chrischen »

ping_pong wrote: post #5

I didn't realize that you could search for things on Apple Photos. That's the main reason why I use Google Photos, because its search capabilities are amazing. When I search for "chicken" it returns both fried chicken, raw chicken and actual chickens. I'll have to check The thing I don't like about Apple Photos is that when you sync with your Apple TV 4K, you can't actually play 4K 60 fps videos on your TV. I don't k…

You can do that in iOS with your photos library (and offline too).

Re: Using SQL to find my best photo of a pelican according to Apple Photos

#20

Post by simonw »

gok wrote: post #19

> Try searching for “dog” and you’ll see all of the photos you’ve taken of dogs! Photos also can differentiate between breeds of dogs

Oh that's brilliant, I hadn't noticed that. I just added all of my photos of Corgis to the demo:

https://dogsheep-photos.dogsheep.net/public/photos_with_appl...

Post reply on HN