<ul>
<li>Mailing list discussion - Source Code for the HPR website
<ul>
<li>What are the best ways to reproduce the HPR site using a static site generator.</li>
<li>I would like the DB to be made public, but I understand why that may not be possible</li>
</ul></li>
</ul>
<p>One interesting thing I read during the discussion is Ken said Every thing needed to recreate an HPR site is in the feed</p>
<ul>
<li>Challenge accepted
<ul>
<li>A lot of my toy projects have been around RSS and podcasts</li>
<li>I am working on a Episode describing a project I did looking for podcasts that have podfaded.</li>
<li>I starting thinking about what data is in the feed and thinking through a process for using the RSS data to recreate the HPR site</li>
</ul></li>
<li>Project
<ul>
<li>Link to Project <a href="https://gitlab.com/norrist/hprfeed2db" class="uri">https://gitlab.com/norrist/hprfeed2db</a></li>
</ul></li>
<li>DATA pulled directly from feed
<ul>
<li><p>explicit</p></li>
<li><p>title</p></li>
<li><p>author_name</p></li>
<li><p>author_email</p></li>
<li><p>link</p></li>
<li><p>description</p></li>
<li><p>summary - I think this is the same as description</p></li>
<li><p>pubdate</p></li>
<li><p>enclosures</p></li>
<li><p>Episode ID - extracted from title - HPR2341</p></li>
<li><p>feedparser and peewee</p></li>
<li><p>full feed to SQLite specs</p>
<ul>
<li>40 Seconds on <strong>My Machine</strong></li>
<li>20M hpr.sqlite</li>
</ul></li>
</ul></li>
<li>Notably Missing from the RSS feeds
<ul>
<li>Episode Series</li>
<li>Episode Tags</li>
</ul></li>
<li>Next steps
<ul>
<li>markdown from db info
<ul>
<li>Main page</li>
<li>Corespondent pages</li>
<li>Episode pages</li>
<li>comments from comments feed</li>
</ul></li>
<li>Manually build other markdown for static pages</li>
<li>about, contributing, ...</li>
<li>Static site generator</li>
<li>I don't think the tags are in the feed data</li>
</ul></li>
</ul>
<pre class="bash"><code>git clone https://gitlab.com/norrist/hprfeed2db
cd hprfeed2db/
python3 -m venv venv
source venv/bin/activate
pip install feedparser peewee
python data_models.py
python feed.py
sqlite3 hpr.sqlite &quot;select count(*) from episode&quot;</code></pre>
