ReadMeFeed / Community knowledge

Prisma

Real questions. Useful conversations. Find the people who know your stack.

Question1 answer· Accepted1 comment3,065 followingPosted 23 Jun 2022, 07:16 UTC54.1K views2,505 votes

prisma can't connect to postgresql

I've tried to connect Prisma with postgreSQL several times. prisma show this error message : "Error: undefined: invalid port number in "postgresql://postgres:password@localhost:5432/linker")". -error -prisma/.env DATABASE_URL=postgresql://postgres:password@localhost:5432/linker -schema.prisma datasource db { provider = "postgresql" url = env("DATABASE_URL")

AI & Data

prisma

postgresql

AI & Data

Question1 answer· Accepted3,065 followingPosted 09 Dec 2021, 10:18 UTC123.9K views4,621 votes

Prisma $queryRaw with variable length parameter list

I am using Prisma with Postgres. I need to use $queryRaw for a particular query due to use of unsupported tsvector type in the underlying table. In this query, I also need to use an 'in' statement where the items in the 'in' list need to be parameterised.. I have tried this const ids = [41, 55] const result = await prisma.$queryRaw`select * from users where

AI & Data

prisma

postgresql

AI & Data

Question1 answer· Accepted3,404 followingPosted 24 Feb 2021, 20:03 UTC102.8K views3,946 votes

M1 Related! - Prisma: Can't reach database server at `database`:`5432`

Since I have moved to the new Apple Silicon architecture my docker setup with nextjs and postgres is not working anymore. The database inside the docker cannot be found by the nextjs server where I am using prisma. The prisma client can't reach the postgres database on port 5432. Can't reach database server at test-postgres : 5432 The migration also does not

Question1 answer· Accepted3 comments4,021 followingPosted 18 Feb 2021, 15:35 UTC85.9K views4,666 votes

@prisma/client did not initialize yet. Please run "prisma generate" and try to import it again

I am using prisma, postgres, docker, kubernets. npx prisma migrate dev working. and npx prisma generate produce below output: ✔ Generated Prisma Client (2.23.0) to ./node_modules/@prisma/client in 68ms You can now start using Prisma Client in your code. Reference: https://pris.ly/d/client import { PrismaClient } from '@prisma/client' const prisma = new Prism

Question1 answer1 comment1,833 followingPosted 21 Mar 2020, 09:42 UTC10.5K views3,934 votes

owner commented

Referential Integrity Preview with In‑Memory SQLite in Prisma Test Suites May Produce Inconsistent Foreign‑Key Enforcement

Goal: Use an in‑memory SQLite database together with Prisma’s preview referentialIntegrity feature so that integration tests enforce foreign‑key constraints identical to a production PostgreSQL instance while keeping credentials out of the test environment. Constraint: The referentialIntegrity preview is experimental and its implementation relies on SQLite P

Community & Careers · Editorial question

prisma referential-integrity

sqlite

AI & Data

Question1 answer· Accepted2,336 followingPosted 10 Jan 2020, 22:11 UTC50.3K views3,330 votes

Error when migrating models to database Prisma

I'm starting a project where I have to learn a new technology and I chose to build a full-stack app with Prisma and Next.js. I'm using both for the first time. I've built front-end apps w/ React.js and feel confident about using Next. However, I'm having a hard time getting started with Prisma. I'm following Prisma's 'Start from Scratch' instructions and I'm