Prisma

P

Prisma

The official Discord server of Prisma! Find us online at prisma.io

Join

Combining raw and standard queries

Hi everyone. I'm developing an API which requires complex filtering. I traverse filters (arbitrary nesting depth) and create where clause. The problem is that I need to implement RegExp based filtering which is not supported natively. As far as I know the only way to make RegExp filtering is via raw queries. Is there a convenient workaround to combine standard query with raw regexp query?...

HI getting Issues in prisma vscode extension

its not giving any problems but just showing red marks in vscode due to new updates of vscode extensions..... i have two schema files working fine as per my intent befor some days now also working fine but showing those problems.......
No description

Generating client without a connection to DB

Hello, I want to generate the client as part of building my docker image. This building of the image will run inside a CI/CD pipeline. Just for generating the client Prisma wants to connect to the database which is not possible inside the pipeline. Is there a way to generate the client without the need of a running DBMS? Why is there the need to have a runnign DBMS in the first place? Greetings...

Prisma P1001 Error Only on One MySQL DB (Same VPS, Sequelize Works)

Hey everyone, I’m running into a weird Prisma issue and could use some help. I have two MySQL databases hosted on the same VPS, but on different ports: * ✅ test DB on 106.129.20.246:3354 (works fine with Prisma)...

`queryCompiler` + `driverAdapters` returns string instead of string[]

Hi, I want to use the new queryCompiler with the driverAdapters. I installed, adapter, added the preview feature, but I get a strange behaviour. I have this schema: ``` model Rule {...

NextJS Prisma Errors 6.7.0

Hey, i try to setup NextJS with Prisma 6.7.0 (provider: 'prisma-client') and Better-Auth But i become some Errors: ``` ⨯ ./src/prisma/client.ts:17:1...

multi-file schema doesn't work @6.7.0

whenever i run prisma generate i get the following error: ```sh Error: Prisma schema validation - (get-dmmf wasm) Error code: P1012 error: Type "RaceEntry" is neither a built-in type, nor refers to another model, composite type, or enum....

Accelerate was not able to connect to your database, The underlying error is: error code: 1016

Hello there! I just subscribed to accelerate PRO and switched my production critical time clock system for a customer (around 200 users, 30k queries per day). It seemed to works good so far for most requests except the fact that sometimes I receive an error such as: This request could not be understood by the server: {"type":"UnknownJsonError","body":{"code":"P6008","message":"Accelerate was not able to connect to your database. The underlying error is: error code: 1016"}} (The request id was: 939892cceb9122de)...

Can't install postgis extension with prisma postgres

I currently use an AWS RDS instance in production that has Postgis installed by default. For local development I have a docker instance running that has postgis installed too. I would like to migrate our databases over to Prisma Postgres for scaleability and pricing reasons, but when I tried to create a Prisma Postgres instance I couldn't enable the postgis extension and got this error: ```...

Language server error

I'm running Prisma 6.7.0 and I'm having a problem with the Languge Server, the prisma extension. The linter and everything have stopped working and it looks like it can't execute the prisma.config.ts file. Do anyone know more about this? `` c:\Users\user\.vscode\extensions\prisma.prisma-6.7.0\node_modules\@prisma\language-server\dist\lib\Schema.js:49 throw new Error(Failed to import config file as TypeScript from "${resolvedPath}". Error: ${error.error.message}`);...

Delete prisma.io account

How can I delete my prisma account? I don’t need it anymore. Thanks!

Module not found errors after switching to 6.7.0 rust free pg

Hi, I keep getting these errors when using the new rust free pg version of Prisma: ``` ⨯ ./lib/generated/prisma/client.ts:21:1 Module not found: Can't resolve './enums.js' 19 | import * as Prisma from "./internal/prismaNamespace.js"...

PrismaClientKnownRequestError

I'm getting error that table can't be found. It's not working even after migrate dev --name users and generate commands. model User { id Int @default(autoincrement()) @id...

What's the purpose of this unit test?

I'm looking into testing database operations so I'm reading this blog post on unit testing. The first unit test written is this: ```ts // src/quotes/tags.service.test.ts...

Missing declaration file with `queryCompiler`?

Hey folks, I'm using the newest setup with 6.7.0: ```prisma datasource db { provider = "sqlite"...

After Prisma v6.7.0 upgrade and huge migration imports, I am facing this typedSql-related error

Unable to solve this problem, is it normal for these typed SQL generated files to have duplicate properties? For example, the main errors are duplicate properties in the generated TS file e.g (see how id field is here twice, along with various other fields): export namespace titleDescListings { export type Parameters = [userId: string, type: string, take: number, skip: number] export type Result = {...
No description

PrismaClientValidationError: Prisma Client was configured to use both the `adapter` and Accelerate,

I am getting this error in my Next.js turbo repo app. I am using 6.7.0 // Here is my code const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL });...

Issues with multiple folder schemas.

Hey all, I am currently using the "prismaSchemaFolder" preview feature, and I went to do: bunx prisma generate but I am now seeing the following: ``` Environment variables loaded from .env...

Issue with Prisma D1 Adapter and Cloudflare Workers: fs.readdir Not Implemented

I’m currently building a website using Next.js, and I am using Prisma ORM to manage a Cloudflare D1 database. However, I’ve encountered an issue. Previously, when I was using Prisma to manage a PostgreSQL database with Next.js on Cloudflare Workers, everything worked perfectly. Recently, I wanted to switch to using Cloudflare’s D1 database, but I’ve run into a problem....