I want to implement tagging on all the content on my website in the same way that del.icio.us and Flickr do it.
I was wondering what the best DB design would be to do this? I figure that FULLTEXT indexing might work the best since they'll be common words and the cardinality would be low.
THe other option of course is a many-many lookup table with proxy tables for all content. Does anyone know how del.icio.us does their tagging database design?
Probably the fastest and most effective way to do it is to make an extra posting field similar to the description hack. But instead of doing it their way, search for every instance of how they implement "title" of posts and do almost the same thing for tags. Including the Word table, which has an "intitle" feature. You add a field to the word table called "intags". Then tags can be searched the same way as titles. Then you'll need to hack up search.php quite a bit.
03-13-2005, 06:06 AM
Database design for tagging
Linear Mode
