scripts

Script registry

A small index of fetchable scripts. Each one is served as plain text, so you can pull it straight into your project with one command.

ingest_real_roster.py

Rebuilds the lectures SQLite database, fetching final_lecture_roster.json from this site and recreating the series and lectures tables.

curl -L https://scripts.<username>.poke.site/ingest_real_roster.py -o ingest_real_roster.py
View raw scriptthen python3 ingest_real_roster.py

app.py

A Streamlit dashboard for tracking books and lectures processing progress, with ETA estimates and a per-series breakdown.

curl -L https://scripts.<username>.poke.site/app.py -o app.py
View raw scriptthen streamlit run app.py

seed_lectures.sql

Plain SQL to build the lectures database directly: drops and recreates the series and lectures tables, then seeds them with the full roster.

curl -L https://scripts.<username>.poke.site/seed_lectures.sql -o seed_lectures.sql
View raw scriptthen sqlite3 lectures.db < seed_lectures.sql