This is the second show looking at the subject of Managing Tags.
In the first show we looked at why we need tags, examined the present system and considered its advantages and disadvantages.
In this episode we will look at a solution using a separate table of tags.
This is a detailed subject so I have written out a set of longer notes for this episode and these are available here.
tags
’ table, its indexes and code to populate it: normalise_tags_1.sql
tags
’ table and its repopulation: refresh_tags.sql
find_shows_sharing_tags.sql
refresh_tags
Unless otherwise stated, our shows are released under a Creative Commons Attribution-ShareAlike 3.0 Unported (CC BY-SA 3.0) license.
The HPR Website Design is released to the Public Domain.