Hey all, the issue I'm having with Prisma is that ...
# prisma-migrate
g
Hey all, the issue I'm having with Prisma is that I'm prototyping new schemas with "db push" but when I try to run "Prisma Migrate dev", it gives the error "Error: P3005 The database schema for
127.0.0.1:3309
is not empty. Read more about how to baseline an existing production database: https://pris.ly/d/migrate-baseline". I'm really not sure how to fix it so my database has my schema changes. I hope this gives better insight into the challenges I'm having.
f
Hey Garrett - what you describe should actually work. Are you prototyping from an existing migration history or from scratch?
g
Hey @Frederik, probably an existing migration history. This is my first project w/Prisma and PlanetScale. I'm using prisma studio and there's some data on my main branch in planetscale
f
I believe the advised workflow with planetscale is to avoid
migrate dev
, only use
db push
and let PS handle the actual migration
g
Interesting! So how would PS know when to update the schema?
f
AFAIK they diff on merging the branch
g
Are there any resources for people coming from a NoSQL background learning prisma w/planetscale? Or from a background not focused on databases