Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at


hpr3637 :: HPR feed to Sqlite

First step in creating a static copy of HPR

<< First, < Previous, , Latest >>

Hosted by norrist on 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
  • 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
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"

Comments

Subscribe to the comments RSS feed.

Comment #1 posted on 2022-07-20 13:18:59 by Ken Fallon

Daily Database Dump in SQL Format

https://hackerpublicradio.org/hpr.sql

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the letter P in HPR stand for?
Are you a spammer?
What is the HOST_ID for the host of this show?
What does HPR mean to you?