3 ms·
no 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 yo
by thrownaway954 9y ago
no 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.