I'd like to add tags to my app. I have several different resources I would want to apply tags to, such as blogs, picture galleries and a few others. More efficient to add tag columns to each resource table or create a seperate table for tags that refrences each resource.
I can't decide on the trade off.
its a web app written in php5 and mysql5
I'd say I'm an advanced beginner at this stuff so my current implementation shows it.