Skip to content

Local dev setup missing shows 706–988 — seed.sql outdated #2172

@2u841r

Description

@2u841r

The seed file (seed/seed.sql) only contains data up to show 705. On a fresh local setup, after running pnpm dev, only those shows are available until the admin import endpoint is manually triggered to sync the rest from the markdown files.

This creates a poor onboarding experience for new contributors — the site works but is missing ~280 episodes. It also makes it harder to investigate bugs affecting newer shows, for example #2170 (host names missing for shows featuring w3cj) was difficult to reproduce locally because those shows (742+) aren't in the seed data.

Two possible fixes:

  1. Update seed.sql periodically to include newer shows — low-tech but requires manual upkeep
  2. Auto-import from markdown on first runpreheat.js already has all the logic via import_or_update_all_changed_shows(), it could call that instead of (or after) seeding when the table is empty. Since all shows exist as .md files in the repo, no DB credentials or network access needed

Option 2 seems more maintainable long-term since the markdown files are always up to date in the repo.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions