hpr3637 :: HPR feed to Sqlite
First step in creating a static copy of HPR
Hosted by norrist on Tuesday, 2022-07-12 is flagged as Clean and is released under a CC-BY-SA license.
python, rss, sqlite.
1.
The show is available on the Internet Archive at: https://archive.org/details/hpr3637
Listen in ogg,
spx,
or mp3 format. Play now:
Duration: 00:07:34
general.
- Mailing list discussion - Source Code for the HPR website
- What are the best ways to reproduce the HPR site using a static site generator.
- I would like the DB to be made public, but I understand why that may not be possible
One interesting thing I read during the discussion is Ken said Every thing needed to recreate an HPR site is in the feed
- Challenge accepted
- A lot of my toy projects have been around RSS and podcasts
- I am working on a Episode describing a project I did looking for podcasts that have podfaded.
- 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
- Project
- Link to Project https://gitlab.com/norrist/hprfeed2db
- DATA pulled directly from feed
explicit
title
author_name
author_email
link
description
summary - I think this is the same as description
pubdate
enclosures
Episode ID - extracted from title - HPR2341
feedparser and peewee
full feed to SQLite specs
- 40 Seconds on My Machine
- 20M hpr.sqlite
- Notably Missing from the RSS feeds
- Episode Series
- Episode Tags
- Next steps
- markdown from db info
- Main page
- Corespondent pages
- Episode pages
- comments from comments feed
- Manually build other markdown for static pages
- about, contributing, ...
- Static site generator
- I don't think the tags are in the feed data
- markdown from db info
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 "select count(*) from episode"