Tiny Tiny RSS: Community

Elimination of duplicates


#1

after having read Filtering duplicates + Logic of dupe elimination I’m wondering whether duplicates’ elimination has progressed in any manner workable for users not on PostgreSQL - perhaps there is a plugin of something? I’m not thinking of anything super sophisticated, just simple URL check - if a URL already exists in the DB just add any found tags / categories to the URL already stored instead of creating the same item again with differing taxonomy?

(I’m sadly not proficient enough in programming, so I cannot realy assess how hard or not it would be to go beyond that. From the utter user pov I’m thinking “the more characteristics match, the likelier an entry should be treated as a duplicate”? (url, guid, timestamp, title?))

If that’s already covered somehow somewhere, I’d be grateful for a related pointer;
much appreciated; cheers - LX


#2

But those URLs will be different for different feeds, won’t they?

From the utter user pov I’m thinking “the more characteristics match, the likelier an entry should be treated as a duplicate”? (url, guid, timestamp, title?)

No, no. The plugin compares only titles of articles. Beg fox to write a plugin around MySQL’s ngram parser.


#3

fox loves MySQL. True story.


#4

that works on any database out of the box, only replace URL with article identifier (as specified by feed - could be URL, could be something else).

you really only need heuristic tools if the feed is broken (that is, same article could be published under different GUIDs) or you’re dealing with multiple feeds reporting on the same event with similar wording (that’s the n-gram plugin).


#5

thank you, guys. :slight_smile:
Now for me as utter non DB-pro :

is there any chance for me to get that to work by my lonesome? :slight_smile: + if so, how might i do that? Cheers -