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

Comments

Subscribe to the comments RSS feed.

Comment #1 posted on 2025-06-18 13:36:52 by Torin Doyle

Appreciated!

Hi norrist. Thanks very much for this. I appreciate it. :-)

Comment #2 posted on 2025-06-18 13:50:18 by Torin Doyle

Database size.

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''.

Comment #3 posted on 2025-06-18 17:40:21 by norrist

Also an SQLite version

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.

Comment #4 posted on 2025-06-25 11:28:29 by Torin Doyle

Not able to use database to find my comments.

Hi norrist.

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

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 :).