4 ms·
Now write an SQL Query to find all photographs that have me and my wife sitting in a boat in them.
by piyush_soni 9y ago
Now write an SQL Query to find all photographs that have me and my wife sitting in a boat in them.
- Piskvorrr 9y ago...minus the ones which are obviously a toaster, while the AI insists they're you and your wife sitting in a boat ;) Now what?
- piyush_soni 9y agoWell, yes, it's not perfect yet, but then I'm pretty sure SQL Queries won't fare any better here ;). Google photos does quite a decent job for me in many cases.
- cpburns2009 9y agoWell, Google receives free Mechanical Turk style image identification through their CAPTCHA (or whatever it's called nowadays).
- deleted 9y ago[deleted]
- piyush_soni 9y agoThat's not the only source of their image identification, if you wanted to say that.
- thrownaway954 9y agoselect * from photos p inner join tags t where t.tag in('you','your wife','boat') and not in('toaster')
- thrownaway954 9y agono problem: select * from photos p inner join tags t where t.tag in('you','your wife','boat') point being is "crap in, crap out". if you properly tag/label your data, you can accomplish anything with sql or machine learning.
- piyush_soni 9y agoYour SQL solution is that each user (or someone sitting in Google) manually tags each and every photo they take for all the tags in the world they can think of (and can't, but will think of in future). Seriously, the general case of this problem just cannot be solved using SQL in a feasible and automatic manner. What Google/Apple (or Microsoft in parts) have achieved here is not an easy thing to achieve by any SQL Query, because that works on nicely populated tables, and without ML those tables are probably not there.