~/talk

Database as Code with PlanetScale and Prisma

Talkat Next.js Conf 2021 · on Tuesday, 2021-10-26· [databases]
slides:none on file

Demo builds a create-next-app named "star app" that uses PlanetScale (MySQL‑compatible serverless) and Prisma to declare a Star model, run Prisma migrate against a shadow branch, and expose an /api/stars route returning rows inserted via Prisma Studio. PlanetScale provides database branching and non-blocking schema changes so the schema change lives in an isolated branch, merges to main via a deploy request, and the deployed Next.js app on Vercel successfully serves the data.

AI-written summary · about

  1. 0:00Start
  2. 0:13What Is Planet Scale
  3. 0:59Prisma
  4. 4:24Create Database
  5. 5:43Install the Prismaclient
  6. 9:53Connect to the Database Locally
  7. 12:11Create a Prisma Js File
  8. 13:45Prisma Studio
  9. 16:24Feedback on Planetscale
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.