Database design for tagging

[ethank]

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?

[GilbertZ]

Follow the logic used by vb for the search and emulate it. The code should be very close. Done right it isn't a minor mod for sure.

[GilbertZ]

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.

[pcollis]

did you ever have any luck with this?

[BoardTracker]

Thread tagging mod is now available here..

https://vborg.vbsupport.ru/showthread.php?t=111887

:cool: