podcast.clips

Overview

A simple web interface for podcast listeners to stream/download episodes and save timestamped segments with comments as well as search transcriptions of episodes.

Automatic transcription is powered by autosubs upon upload of new content.

---

Goals

• docker-compose backend
• mariaDB tables created
  • episodes
  • segments
  • users
  • user levels (owner, moderator, normal)
  • tags
  • segment voting, thumbs up/down or star
• Figuring how how to implement a php submit form within a javascript loop
• Uploading episodes (owner ownly)
• Searching and filtering of segments
• Searching transcriptions with links to episode/timestamp
• Exporting clips
  • possibly appending clips together
• User management (kinda)
• Make it not ugly
• Other things

---

Made with The After Disaster Podcast in mind.

---

Setup Instructions

clone the repository

git pull https:/mrplow/podcast.clips.git

cd podcast.clips

Edit .env_mariadb and change the root password, probably want a decent password 😉

MYSQL_ROOT_PASSWORD=654321

Edit connect.php and change the username and password variable which will be used by php

$username = "databaseuser";
$password = "changeme";

Edit setupdb/01-create-database-and-user.sql and change the username (in two places) and the password to match the connect.php variables

CREATE USER 'databaseuser'@'%' IDENTIFIED BY 'changeme';
GRANT CREATE, ALTER, INDEX, LOCK TABLES, REFERENCES, UPDATE, DELETE, DROP, SELECT, INSERT ON `podcast_clips`.* TO 'databaseuser'@'%';`

start docker-compose

docker-compose up -d

Login to the site http://localhost:8889

The first user to create an account will be set as the owner

Optionally setup an HTTPS reverse proxy with nginx or apache (google it)