Using SQL to find my best photo of a pelican according to Apple Photos
21–30 of 38 posts
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#22If the photo manager let you compare any set of photos two at a time, you could (with n-choose-2 keypresses) find something close to a total order of the set. Then you'd easily be able to choose the best photos of the whole set, as well as the best ones of each subject/set of duplicates. No machine learning would be required.
Has anyone encountered a tool like this?
Edit: You wouldn't get a stable total order because the pairwise comparisons might not hold transitively, but something like Elo ranking could work here.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#23Re: Using SQL to find my best photo of a pelican according to Apple Photos
#24How do you guys go about that?
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#25I don't have space for all my photos on my laptop, but I would like to use Apple photos. How do you guys go about that?
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#26A feature I've long wanted to see in a photo management tool is ranking based on pairwise comparisons. Say you went on a trip and had 200 "keeper" photos, but that's still too many to publish in an online album, and many of them are near-duplicates anyway. If the photo manager let you compare any set of photos two at a time, you could (with n-choose-2 keypresses) find something close to a total order of the set. Then…
https://play.google.com/store/apps/details?id=me.delrieu.bes...
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#27Earlier 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.
But i do think it fetches newer models given the chance.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#28Earlier quoted context omitted.
Is the Windows 10 one truly offline or does it eventually phone home in some way? Genuinely asking out of curiosity.
The classification model runs offline. I can say this because i had it classify a lot of pics while I was out on a trip with no internet. But i do think it fetches newer models given the chance.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#29Anybody tried with Lightroom CC or Lightroom Classic. Classic at least (I haven't checked CC), uses SQLite internally.
Re: Using SQL to find my best photo of a pelican according to Apple Photos
#30So apparently some machine learning model is secretly judging how aesthetic your photos are. I would have thought judgements of aesthetics would somehow be the last bastion of human subjectivity and human intellect. Apparently I'm wrong.