prisma

18 Aug

Prisma db push or pull stuck?

stp2y0 CommentsNewscoding, community, database, development, engineering, help, inclusive, prisma, software, supabase

Fix for Prisma connection stuck. When working with Prisma and Supabase DB, I got an issue with the Prisma CLI getting stuck during prisma db push and prisma db pull. I eventually for to know that the issue often arises when using a Supabase connection string with the pooled connection (port 6543). For example, running npx prisma db push took 9 minutes here and still failed: The Fix To resolve this, I needed to switch to a direct connection string using port 5432 instead. I tried changing it on the Supabase dashboard and then saw this: What you need to…

30 Jul

Error: P1003 : Prisma Migrate could not create the shadow database.

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, migrate, p1003, postgres, prisma, software

Fix your Prisma Migration error: 1. Update your .env config . DATABASE_URL="postgresql://postgres:asdf4321@127.0.0.1:5432/postgres" SHADOW_DATABASE_URL="postgresql://postgres:asdf4321@127.0.0.1:5432/postgres" Enter fullscreen mode Exit fullscreen mode 2. Update schema.prisma file. generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL") shadowDatabaseUrl = env("SHADOW_DATABASE_URL") } Enter fullscreen mode Exit fullscreen mode That's solved now. 3. Now migrate your Database. npx prisma migrate dev Enter fullscreen mode Exit fullscreen mode Source link lol