Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 13 Mar 2005, 07:06
ethank's Avatar
ethank ethank is offline
Join Date: Oct 2001
Database design for tagging

I want to implement tagging on all the content on my website in the same way that 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 does their tagging database design?
join the revolution .- -. -.. / -- .- -.-- -... . / .. - ... / - .. -- . / - --- / .-.. .. ...- .
Reply With Quote
Old 26 Aug 2005, 10:12
GilbertZ GilbertZ is offline
Join Date: Nov 2004
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.
Reply With Quote
Old 29 Aug 2005, 00:04
GilbertZ GilbertZ is offline
Join Date: Nov 2004
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.
Reply With Quote
Old 11 Oct 2005, 09:08
pcollis pcollis is offline
Join Date: Sep 2005
did you ever have any luck with this?
Reply With Quote
Old 01 Apr 2006, 09:49
BoardTracker's Avatar
BoardTracker BoardTracker is offline
Join Date: Dec 2005
Thread tagging mod is now available here..

Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 00:11.

Layout Options | Width: Wide Color: