Using SQL to find my best photo of a pelican according to Apple Photos
1–10 of 38 posts
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#2datasette keeps getting cooler and cooler, huh.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#3This 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.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#4datasette keeps getting cooler and cooler, huh.
I think it reached peak coolness back in the 70s.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#5I 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 know why that is, but it won't work. That's extremely disappointing to me, and I don't understand what the reason is, unless the AppleTV 4K is underpowered.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#6I 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-...
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#7I 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.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#8Nice work, thank you.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#9My favourite demo is hidden pretty deep in the text - here's a SQL query that shows the machine learning labels that were applied to each photo by Apple Photos:
https://dogsheep-photos.dogsheep.net/public?sql=select%0D%0A...
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#10This is really cool -- thank you for sharing!