Live examples
Three pages on live PBS SoCal data. Each is a static page on this site that calls one Plexara Application, as you. The whole thing was built by asking the PBS SoCal MCP (Plexara).
TV schedule
PBS SoCal, PBS SoCal Plus and PBS SoCal KIDS for three weeks, with show posters, what's on now, and every day answered in milliseconds.
Broadcast reach
Average Nielsen reach per airing by channel for twelve months, last month's top shows, and the week ahead, refreshed on a schedule.
Suggest a show
A form that writes to the application's database. You see your own suggestions; everyone sees the tally, which names no one.
How the examples are built
One application, pages-demo, holds every moving part. This site's dev and prod environments are parts of it, so their addresses answer its endpoint.
Data Estate
Protrack schedule, Nielsen NLTV reach and the show poster mirror, in the PBS SoCal warehouse.
pages-demo-sync
A scheduled script copies three weeks of airings and a reach summary into the application's database.
pages_demo database
Airings, dashboard snapshots and suggestions, with row-level security on suggestions.
/endpoints/pages-demo
One endpoint script answers schedule, dashboard and suggestions for these pages.
Built by asking
The schema, both scripts and their tests, the endpoint, the schedule, the release and these pages were all made through the PBS SoCal MCP (Plexara).
Reviewed before release
Scripts saved only with passing tests; the database changed only by migrations; the pages reviewed in dev, then released with the application.
Private like everything else
These pages and their endpoint open only for people this site is shared with. Nothing here is public.