[HN Gopher] Using SQL to find my best photo of a pelican accordi...
___________________________________________________________________
Using SQL to find my best photo of a pelican according to Apple
Photos
Author : markx2
Score : 97 points
Date : 2020-05-22 11:45 UTC (11 hours ago)
(HTM) web link (simonwillison.net)
(TXT) w3m dump (simonwillison.net)
| hprotagonist wrote:
| datasette keeps getting cooler and cooler, huh.
| goldenkey wrote:
| I think it reached peak coolness back in the 70s.
|
| https://en.wikipedia.org/wiki/Commodore_Datasette
| renewiltord wrote:
| 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.
| simonw wrote:
| 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
| simonw wrote:
| My 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...
| HGK1989 wrote:
| This is really cool -- thank you for sharing!
| ping_pong wrote:
| 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 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.
| sp332 wrote:
| Lots of details about Apple TV 4k video playback at
| https://www.theverge.com/2017/9/21/16341876/new-apple-tv-4k-...
| ping_pong wrote:
| 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.
| hadrien01 wrote:
| The Photos app in Windows 10 has the same capability. And the
| Apple and Microsoft apps are totally offline, unlike Google
| Photos.
| giancarlostoro wrote:
| Is the Windows 10 one truly offline or does it eventually
| phone home in some way? Genuinely asking out of curiosity.
| annoyingnoob wrote:
| Nice work, thank you.
| jmarcher wrote:
| Anybody tried with Lightroom CC or Lightroom Classic. Classic at
| least (I haven't checked CC), uses SQLite internally.
___________________________________________________________________
(page generated 2020-05-22 23:01 UTC)