Prisma + Supabase self-hosted
Hi I've got an issue I can't seem to find a solution to.
I've setup a self-hosted Supabase on a Hetzner cloud server, and I can no longer use
npx prisma ... commands, all of them returns the error below:
Error: P1001: Can't reach database server at {server_ip}:5432
...Remix, prisma, neon, fly.io: Can't reach database server
Hi, I'm using prisma in a remix app deployed to fly.io and connecting to a neon db. Everything was deploying and working fine at first, then after a deployment on June 18th, the prisma client keeps showing "Can't reach database server at DATABASE_URL".
After trying out some ideas with someone from neon, I traced through my server logs to find the last time it worked, and found that between a successful deployment and the broken one, prisma v6.10.0 was related. PNPM automatically installed that when building my docker image and I'm not finding anything else that might be related.
I tried pinning prisma to v6.9.0, but I'm still getting the same error. I'm not sure how to reproduce this or if the problem is with the prisma client so I can't really open a bug report. Has anyone else see this issue? I'm not using any prisma adapters so I'm probably using a rust engine. I'm also able to run prisma cli commands and connect to the neon database with prisma studio without any issues....
Does declaring ‘prisma-client’ in a provider eliminate the need to install @prisma/client?
v6.10.1
```prisma
generator client {
provider = "prisma-client"...
PrismaClientInitializationError – Missing Query Engine Binary for rhel-openssl-1.0.x on Vercel
Hello,
I'm encountering a PrismaClientInitializationError that started recently. Everything was working perfectly yesterday, but now I'm getting an error at runtime when deploying on Vercel.
To resolve it, I tried updating my Prisma schema with the following:...
how to setup connection pooling string in hono
where do i put connectionpooling_url in .env or in wrangler.json. and where to put DATABASE_url from postgres
i try to put both of them in .env connectionpooling_url as DATABASE_URL and database_url as DIRECT_URL and it worked
npx prisma migrate and generate was working
but the tutorial i am following is explaining how to setup at production level but the problem is that it is 1 year old and things have change
he was telling to put url in wrangler.toml but i don't have it i have wrangler.jsonc so what did i do wrong and how do i setup ?...
Intellisense switches to generated schema instead of the one I'm editing
i'm using the prisma intellisense in cursor (basically fork of vscode), and also generating the prisma client into a custom directory (as required)
```ts
generator client {
provider = "prisma-client-js"...
is there a local instance or something?
I definitely am pulling my data from somewhere, but it's not my production environment.
when i do, prisma.user.findMany() I see all the users I created. however, my production database and prisma studio are still empty.
where can I find this mysterious database and access it?...
Prisma PG adapter error in hosted environments (`this.client.connect(...).catch is not a function`)
```
TypeError: this.client.connect(...).catch is not a function
File "/app/node_modules/@prisma/adapter-pg/dist/index.js", line 584, col 51, in PrismaPgAdapter.startTransaction
const conn = await this.client.connect().catch((error) => this.onError(error));
File "/app/node_modules/@prisma/client/runtime/client.js", line 71, col 31668, in #r...
multiple relation with same field
let's assume i want to use the same field to create a relation to different tables, is it possible?
I'm thinking something like this
LinkTable{
id String @id @default(uuid())...
ENOENT: no such file or directory, open '/var/task/prisma/query_compiler_bg.wasm'
Query compiler doesn't work when deployed on Vercel...
```
Unhandled Rejection: Error: ENOENT: no such file or directory, open '/var/task/prisma/query_compiler_bg.wasm'
at Object.getQueryCompilerWasmModule (.next/server/chunks/1024.js:1:239583)...
Standard Postgres DATABASE_URL with Netlify extension (or derive username/password from API key)
If I'm understanding correctly, the Prisma Postgres Netlify extension provides a
DATABASE_URL using the prisma+postgres:// scheme. Is there a way to get credentials for a standard Postgres connection instead?Why Stick With Prisma in 2025?
I’ve been a fan of Prisma since v1 — used it on my very first React project back in the day, and created a project with v2 as well. Haven’t touched it in a while, and now I’m seeing a lot of love for newer tools like Drizzle.
Curious to hear strong opinions: why should I stick with Prisma today? What does it still do better than alternatives in 2025 — whether that’s performance, DX, ecosystem, type safety, or something else entirely?
Not looking to start an ORM war — just genuinely interested in what keeps long-time (or recent) users loyal to Prisma. Sell me on it. 😄...
Prisma opening up connections for every repository query
Hey guys! My name is Rodrigo and im having some trouble with my repositories in an application taking longer times because of prisma:engine:connection.
From what I understand, Prisma has a pool of connection and it doenst need to open new connection for every query. But thats not whats Im seeing.
For better context, this application uses Node with Express and Prisma. I have a Adapter, Controller, Service and Repository architecture....
adapter-mongodb
I’ve been trying to implement and use a custom adapter-mongoDB for Prisma, but I'm encountering the following error: ``` err: {
"type": "PrismaClientConstructorValidationError",
"message": ""adapter" property can only be provided to PrismaClient constructor when "driverAdapters" preview feature is enabled.\nRead more at https://pris.ly/d/client-constructor",
"stack":
PrismaClientConstructorValidationError: "adapter" property can only be provided to PrismaClient constructor when "driverAdapters" preview feature is enabled....
PrismaClientInitializationError with docker
Hi, i have this problem:
``
PrismaClientInitializationError: Prisma Client could not locate the Query Engine for runtime "debian-openssl-3.0.x".
This happened because binaryTargets` have been pinned, but the actual deployment also required "debian-openssl-3.0.x"....
passing a varial to queryRaw
hello, what am i doing wrong?
``ts
db.$queryRawUnsafe(
SELECT "value" #> '{$1}' AS value, name...Problems with the Prisma repository pattern?
Is there an issue with the repository pattern I've configured?
```ts
/* eslint-disable */
export class CommonRepository<...
Build failed because of webpack errors
Hi folks! I'm having this issue trying to build/deploy next.js app integrated with prisma on Vercel. It seems that I'm having some permission issues but i don't understand why:
`next build▲ Next.js 15.3.3...
Prisma VScode Extension - Local DB issues
Using latest versions of prisma + latest vscode extension for prisma in cursor.
Also on WSL.
Using any local database commands fail (im assuming its a port forwarding issue) but not sure how to fix it.
Is there any difference here than running prisma dev in another shell?...
How to clone/migrate data from prisma postgresql to self hosted pg
I have a dev database on prisma pg which I have been using for production and i have accumulated some user data(23MB).
What is the best way to migrate/clone the database to a (1) prisma production database and (2) self hosted coolify postgresql?
I have tried connecting both(prisma & coolify) of them via pgadmin 4 and tried a simple backup and restore approach which failed(partially), seeing the data on the target database but pgadmin said "failed" with getting error:
```...