NAME

Fry::Lib::CDBI::Tags - A Class::DBI library of Fry::Shell for dealing with tables containing a tag column.

DESCRIPTION

These functions deal with tables that contain tags. A tag is a keyword associated with a row. Usually there are multiple tags associated with a row. Currently all tags for a given row are put in one column 'tags' (name can be changed via $tag_column) delimited by a comma (changed via the variable tag_delimiter). This is a temporary solution since the table isn't normalized due to the multivalued tags column.

How could I use a tagged table?

Mainly as a mnemonic device. For example, I have a table that contains all CPAN modules. To easily remember a module I'll tag it with words like 'handy,todo,try,dbi'. These tags serve as categories for a given module and thus serve as a good memory aid when trying to remember a module that's 'on the tip of my tongue'.

COMMANDS

Note: @search_term indicates same input syntax as search commands in Fry::Lib::CDBI::Basic

Search based

	tagcount(@search_term): returns groups of tags, grouping them by count
	tagname(@search_term): returns tag count for every tag
	auto_outline(@search_term): returns an outline result of the top $otlnum tags for the given search  
		Ie if a search ('tags=perl) 's three most numerous tags are
		'dbi,magazine,sites', this function would return a result as follows:

			dbi
				#results containing tags dbi and perl
			magazine	
				#results containing tags magazine and perl
			sites
				#results containing tags sites and perl
	sorted_tag_list(@search_term): returns list of sorted tags
				
Menu based
	tagname_obj(@cdbi): returns &tagname output
	tagcount_obj(@cdbi): returns &tagcount output

SEE ALSO

Fry::Shell,Fry::Lib::CDBI::Outline

http://del.icio.us is a community bookmarking site which uses tags heavily.

Rubric is a CPAN implementation similar to it.

TODO

Normalize the tags column by adding another table to add a LOT more functionality to tags.

AUTHOR

Me. Gabriel that is. If you want to bug me with a bug: cldwalker@chwhat.com If you like using perl,linux,vim and databases to make your life easier (not lazier ;) check out my website at www.chwhat.com.

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.