Live data from Hacker News

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

simonwillison.net

21–30 of 38 posts

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

#22
A 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 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

#25

I 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?

I have never managed to get iCloud Photos work on Windows. That means I can't even actually download all the photos I have taken. It's one horrible app.

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

#26
post #22

A 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…

I created an Android app to rank your photos (up to 30 at a time) using an AI (it is a new feature, I did not update the play store page yet).

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

#27

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.

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

#28
post #27

Earlier 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.

I am okay with it fetching models my issue is it uploading my files without consent. Thanks for sharing I had no doubt they would do this I just would like to know the whole picture. I am sick of companies just uploading things without consent. What if I am a competitor? Now you stole my IP.

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

#29

Anybody tried with Lightroom CC or Lightroom Classic. Classic at least (I haven't checked CC), uses SQLite internally.

Did later versions of classic have any automatic classification? You can indeed use the database to get your tags etc out, but at least the versions I used didn't have any automatic tagging/labeling features.

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

#30
post #21

So 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.

This is actually a really interesting for me because I take a lot of pictures many are similar and I don’t actually care which ones I keep objectively thinking but when I look at them I like one aspect of one picture and a different aspect of a nearly identical picture. I was recently thinking about a tool that would just take all the photos from an event and just filter out a handful that it thinks are best and offer to delete the rest.
Post reply on HN