<h1 id="managing-tags-on-hpr-episodes---3">Managing tags on HPR episodes - 3</h1>
<h2 id="introduction">Introduction</h2>
<p>This is the third (and last) show looking at the subject of Managing Tags relating to HPR shows.</p>
<p>In the <a href="https://hackerpublicradio.org/eps.php?id=2245" title="Managing tags on HPR episodes - 1">first show</a> we looked at why we need tags, and examined the advantages and disadvantages of the present system of storage. We considered the drawbacks of this design when searching the tags.</p>
<p>Then in the <a href="https://hackerpublicradio.org/eps.php?id=2260" title="Managing tags on HPR episodes - 2">second show</a> we looked at a simple way of making a tags table and how to query it in order to fulfil the requirements defined in the first show.</p>
<p>In this show we’ll look at a more rigorous, efficient, “<em>normalised</em>” solution.</p>
<h2 id="long-notes">Long notes</h2>
<p>I have written out a set of longer notes for this episode and these are available <a href="https://hackerpublicradio.org/eps/hpr2270/full_shownotes.html">here</a>.</p>
<h2 id="links">Links</h2>
<ul>
<li>Previous shows in this set:
<ul>
<li><a href="https://hackerpublicradio.org/eps.php?id=2245">“<em>Managing tags on HPR episodes - 1</em>”</a> - episode 2245</li>
<li><a href="https://hackerpublicradio.org/eps.php?id=2260">“<em>Managing tags on HPR episodes - 2</em>”</a> - episode 2260</li>
</ul></li>
<li>Mike Ray’s show on this subject: <a href="https://hackerpublicradio.org/eps.php?id=1569">episode 1569, “<em>Many-to-many data relationship howto</em>”</a></li>
<li><a href="https://hackerpublicradio.org/report_missing_tags.php">HPR page listing shows missing summaries and tags</a></li>
<li>Included files:
<ul>
<li><a href="https://hackerpublicradio.org/eps/hpr2270/full_shownotes.html">Detailed notes</a> for this episode</li>
<li>Image representing a many to many relationship: <a href="https://hackerpublicradio.org/eps/hpr2270/table_relationships.svg"><code>table_relationships.svg</code></a></li>
<li>SQL to create the tables: <a href="https://hackerpublicradio.org/eps/hpr2270/normalise_tags_2.sql"><code>normalise_tags_2.sql</code></a></li>
<li>SQL to create a view: <a href="https://hackerpublicradio.org/eps/hpr2270/eps_hosts_tags_view.sql"><code>eps_hosts_tags_view.sql</code></a></li>
<li>Perl script to manage the tables: <a href="https://hackerpublicradio.org/eps/hpr2270/refresh_tags_2"><code>refresh_tags_2</code></a></li>
</ul></li>
</ul>