Implementing Tagging
I intend to add tagging to this weblog sometime soon (à la del.icio.us, Flickr, and others, that is), so I did some research1. Two useful posts I found:
- “Matching on data intersection across a many-to-many join with Ruby on Rails
” by Peter Cooper, and - “Tags: Database schemas” by Philipp Keller.
For future reference (both from Cooper):
- “Find all many-to-many relationships which are tied to an arbitrary number of other many-to-many relationships,” and
- “Find items with similar (or as many as possible) relationships – for a ‘related posts’ box etc.”
1 And don’t you just love blogspace: there’s a blog on “database technology for tagbased applications.”