HPR4403: How to get your very own copy of the HPR database

Hosted by norrist on 2025-06-18 01:00:00

---

This show has been flagged as Clean by the host.

Get your own copy of the HPR database

reset_hpr.sh

systemctl start mariadb
curl https://hackerpublicradio.org/hpr.sql > hpr.sql 
mariadb -e 'drop database hpr_hpr'
mariadb -e 'create database hpr_hpr'
mariadb hpr_hpr < hpr.sql 
mariadb -e 'select  count(*) from eps' hpr_hpr
mariadb -e 'select * from comments where comment_author_name="Torin Doyle" \G' hpr_hpr

Provide feedback on this episode.

HPR Comments

---

Torin Doyle says: Appreciated!

RE: hpr4403::2025-06-18 How to get your very own copy of the HPR database by norrist
00:02:52 Listen in ogg, opus, or mp3 format.
Hi norrist. Thanks very much for this. I appreciate it. :-)

---

Torin Doyle says: Database size.

RE: hpr4403::2025-06-18 How to get your very own copy of the HPR database by norrist
00:02:52 Listen in ogg, opus, or mp3 format.
Hi norrist.

I downloaded the database and it's only 19.1 MB in size. Is that right.

I'm not able to open it in the Flatpak, 'DB Browser for SQLite Version 3.13.1'. I get an error like "Error importing data from record number 23184. Unexpected end of file. ...

I then ran the commands in this episode page with mariadb and get errors in the terminal like 'Access denied for user 'torin'@'localhost''.

---

Torin Doyle says: Not able to use database to find my comments.

RE: hpr4403::2025-06-18 How to get your very own copy of the HPR database by norrist
00:02:52 Listen in ogg, opus, or mp3 format.
Hi norrist.

Running as sudo did not work. Also, I'm unsure as to how to run those scripts. Not to worry. Thanks, anyway.

---

norrist says: Also an SQLite version

RE: hpr4403::2025-06-18 How to get your very own copy of the HPR database by norrist
00:02:52 Listen in ogg, opus, or mp3 format.
I should have added in the show that there are scripts available to download the db and load the sql into a sqlite file. This is probably a much easier option if you dont have experience managing mariadb.

The scripts are in the hpr_generator project:
https://repo.anhonesthost.net/HPR/hpr_generator/src/branch/main/utils

If you try the method in the show and are getting permission denied errors, try running the commands as root. Sometimes the root user has blanket permissions to the databases.

Mastodon Comments