<h1 id="managing-tags-on-hpr-episodes---2">Managing tags on HPR episodes - 2</h1>
<h2 id="introduction">Introduction</h2>
<p>This is the second show looking at the subject of Managing Tags.</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, examined the present system and considered its advantages and disadvantages.</p>
<p>In this episode we will look at a solution using a separate table of tags.</p>
<h2 id="long-notes">Long notes</h2>
<p>This is a detailed subject so I have written out a set of longer notes for this episode and these are available <a href="https://hackerpublicradio.org/eps/hpr2260/full_shownotes.html">here</a>.</p>
<h2 id="links">Links</h2>
<ul>
<li>Previous show 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>
</ul></li>
<li>HPR web page listing <a href="https://hackerpublicradio.org/report_missing_tags.php">shows missing summaries and tags</a></li>
<li><a href="https://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows">Stack Overflow article about splitting CSV data</a></li>
<li>A more detailed article about <a href="https://tagging.pui.ch/post/37027745720/tags-database-schemas">tags in a database</a></li>
<li>HPR show 1965 <a href="https://hackerpublicradio.org/eps.php?id=1965">“<em>Adding SQLite as a datasource to SQLeo</em>”</a></li>
<li>Resources:
<ul>
<li><a href="https://hackerpublicradio.org/eps/hpr2260/full_shownotes.html">Detailed notes</a> for this episode</li>
<li>SQL to define a ‘<code>tags</code>’ table, its indexes and code to populate it: <a href="https://hackerpublicradio.org/eps/hpr2260/normalise_tags_1.sql"><code>normalise_tags_1.sql</code></a></li>
<li>SQL to perform the emptying of the ‘<code>tags</code>’ table and its repopulation: <a href="https://hackerpublicradio.org/eps/hpr2260/refresh_tags.sql"><code>refresh_tags.sql</code></a></li>
<li>SQL to find all shows related to a given show using tags: <a href="https://hackerpublicradio.org/eps/hpr2260/find_shows_sharing_tags.sql"><code>find_shows_sharing_tags.sql</code></a></li>
<li>Perl script to manage the tag table: <a href="https://hackerpublicradio.org/eps/hpr2260/refresh_tags"><code>refresh_tags</code></a></li>
</ul></li>
</ul>