Anthony Campolo
09/02/2021, 12:22 AMyarn rw prisma migrate dev
, (which is basically just a wrapper around prisma migrate dev
) with a Supabase database and I’m getting this error:
Error: Database error
Error querying the database: db error: ERROR: unexpected response from login query
0: sql_migration_connector::flavour::postgres::sql_schema_from_migration_history
at migration-engine/connectors/sql-migration-connector/src/flavour/postgres.rs:375
1: migration_core::api::DevDiagnostic
at migration-engine/core/src/api.rs:89
My Prisma schema:
datasource DS {
provider = "postgresql"
url = env("DATABASE_URL")
}
generator client {
provider = "prisma-client-js"
binaryTargets = "native"
}
model User {
id Int @id @default(autoincrement())
githubId Int
handle String @unique
email String @unique
createdAt DateTime @default(now())
}
model Repository {
id Int @id @default(autoincrement())
githubId Int
fullName String
createdAt DateTime @default(now())
}
Redacted .env
file:
DATABASE_URL=<postgres://postgres:password@db.xxxx.supabase.co:6543/postgres>
SUPABASE_URL=<https://xxxx.supabase.co>
SUPABASE_KEY=xxx
SUPABASE_JWT_SECRET=xxx
Anthony Campolo
09/02/2021, 12:36 AM