[Tagdb] Tags and data storage

[Vivek Krishna]

Joshua,
> tag in a separate dB row.  Other sites allow for phrases and separate them
> by commas but again, store each tag in a separate row.
>
> I can understand from an ease of search POV why you would do this, but if
> your table is denormalized, like mine, I am afraid the table size will grow
> very very large very quickly.
>
> Does anyone have any recommendations/thoughts on tag storage?

I feel having a seperate tag  table is the way to go.. Having a tag
list string field for each item means that you need to do a string
operation each time a user wants to list items by a tag and if tags
get used often they get repeated,which can be avoided by giving ids
for tags.
A normalized approach means you have the following 3 tables
tag id -tag name
item id  tag id
item .. item id

It may seem that 3 tables may get huge,but this allows you to store
info like who created the tag and do tag connection queries .

In addition how long can the comma seperated list be? the length y ou
define limits the number of tags per item.
Vivek