So, I was bored and made a thing: it checks images using perceptual image hashing and filters out ones similar to those first encountered in other (older) articles. The idea here is to filter out reposted images on reddit and stuff like that.

The whole thing is a *work in progress* but seems to work surprisingly well so far.

select url,phash,unique_1bits((select phash from ttrss_plugin_img_phash_urls where url ='http://imgur.com/something.jpg'), phash) AS distance from ttrss_plugin_img_phash_urls order by distance limit 5;