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

block_scanner.ts

A local, read-only integrity scanner for your own lectures.db. It walks the lecture id space (500 to 45,000) and reports missing-id gaps, orphaned lectures, empty series, and duplicate or missing video ids, writing results to findings.json as it goes. Runs on your machine and makes no network calls.

curl -L https://scripts.<username>.poke.site/block_scanner.ts -o block_scanner.ts
View raw script
Run it locally:
  1. 1bun run block_scanner.ts --db ~/lectures.db

test_db.ts

A read-only inspector for a local SQLite file. Lists every table and view with its row count and DDL, and dumps the columns for any lectures / lecture series object. Handy for confirming what your database actually holds.

curl -L https://scripts.<username>.poke.site/test_db.ts -o test_db.ts
View raw script
Run it locally:
  1. 1bun run test_db.ts --db ~/lectures.db

find_db.ts

Hunts your home folder for SQLite files and reports which ones contain a lecture series table, printing each match's path, file size, and row count. Skips permission-heavy folders like Library and node_modules.

curl -L https://scripts.<username>.poke.site/find_db.ts -o find_db.ts
View raw script
Run it locally:
  1. 1bun run find_db.ts

inspect_all_dbs.ts

Dumps the full schema of every SQLite file under your home folder: path, size, and every table and view with its row count. Use it to find a dataset when you are not sure which table or database it lives in. Skips permission-heavy folders.

curl -L https://scripts.<username>.poke.site/inspect_all_dbs.ts -o inspect_all_dbs.ts
View raw script
Run it locally:
  1. 1bun run inspect_all_dbs.ts