I am continuing to have a pretty bad time with migrations. I basically never want prisma to delete all my data, even in dev.

What is the correct way to do migrations? Modify schema.prisma then run something, or modify the database then running something?

Also, how do I start again - like, just give me a schema from whatever is in the database. Then I would expect no migrations to be necessary.

Responded here: https://prisma.slack.com/archives/CA491RJH0/p1663675189328399?thread_ts=1663602606.227959&cid=CA491RJH0

Hi all, im using docker and have successfully set up a connection to a dockerized postgresql within my dockerized prisma node app. However, I'm getting error " The table

public.users

does not exist in the current database". I have the prisma schema files that are ready to update, but what command do I actually use to update the db schema? I know I need to use prisma CLI I think

Hi everyone. I have problem in my Application dockerized prisma with mysql and node 16, about this I'm use the command docker-compose to set up my API. However, I'm getting error "Error: Command failed: /usr/src/app/node_modules/.bin/mmdc -i /tmp/prisma-erd-MvByKD/prisma.mmd -o /usr/src/app/prisma/ERD.svg -t forest -c /tmp/prisma-erd-MvByKD/config.json" in the last step. Even after updating my prisma.schema file the problem remains, but I don't know solve this issue. Can someone help me please? Thanks in advance.

Hi everyone 👋 I am trying to use Prisma with single store (cloud-native database singlestore), Have anyone used Prisma with SingleStore before? it seems there is an open issue related to SingleStore: https://github.com/prisma/prisma/issues/2935 i am experiencing a weird issues while i am pushing the db changes one of the issues : i have to do this for each model @@id

@@index([id], map: "__SHARDKEY")

second issue: incorrect

dateTime           _DateTime_       @db.DateTime()

correct

dateTime           _DateTime_       @db.DateTime(0)

Thanks in advance 🙏

This is more of a random theory question about prisma and where you have some logic live. I have a table

contacts

and a table

addresses

. Table

addresses

has a

contactId

and

isPrimary

. And

contacts

has a

primaryAddressId

in the table. If someone updates or adds an Address that

isPrimary = true

then it should set the contact’s

primaryAddressId

. So where would you as a prisma dev have this live? • Database Trigger • Middleware • Just my api code? • Somewhere else? This is actually a part of a bigger internal discuss I have been having and was curious this community’s thoughts

How can I stop data loss here?

Hey guys, anyone had much luck with tracing?

And yet, as you can see from the Jaeger UI, we are only seeing Prisma traces. Does anyone know how we can make these more comprehensive by including the entire request trace?

hi everyone, I have a question regarding migration. All of the scenario is against my local db. • Let’s say I have a main branch where migration 1 is the latest. • I then create feature 2 branch and make a new migration 2. • When I finish with feature 2, I then go back to main branch and create new branch for feature 3. At this point, my db is having the changes done by migration 2. How can I correctly create a migration 3 for this branch? Currently, whenever I do it, it will ask me to reset db since the number of migration is not similar (migration 2 doesn’t exist on this branch). So a couple of Qs beside that too: • how should I deal with that when this get merged and deploy? Will Prisma asks my prod db to reset too? • Will it be any different if I choose to merge feature 2 before or after feature 3? Remember that feature 2 is done before feature 3, so technically speaking, when both are merged, migration 2 will be before migration 3 • Am I doing this one wrong? I keep having the feeling that I should make a separate branch to update the db and merge it to the main branch asap to allow other branches to have access to the migration, but it doesn’t always feel right to do it.

Does anyone have any experience with setting up Prisma/ PostgreSQL on a local machine and then connecting to it through your external IPv4? I can connect to it through my LAN no problem (using internal IPv4), but when I try and use my external IPv4 (after port forwarding and allowing inbound & outbound traffic on the machine through ufw) it just won't connect.

Message: Error in Prisma Client request: 


Invalid `prisma.entry.findMany()` invocation:


Can't reach database server at `external_ipv4_redacted`:`5000`

Please make sure your database server is running at `external_ipv4_redacted`:`5000`.
  
Query:
{
  "modelName": "Entry",
  "operation": "findMany",
  "args": {
    "take": 100,
    "skip": 0,
    "select": {
      "id": true
    }
  }
}

Hi Varshith 👋 Did you had a look at baselining docs? Baselining is usually used for data that must be maintained (like production), which means that the database cannot be reset

Hello techies, im building a fullstack app with Nextjs, Prisma, and PostgreSql. I am trying to activate the next-auth with my github. Everything is configured fine, when I connected it with local host and configured the oauth app on github, i can use my github to login to the app, but when I try to connect the nextauth_url with the url of my prospective vercel app...its saying server error. Am i in the right place to get answers? this is the repo (https://github.com/muhammedctgr/p-hammed-blogr-nextjs-prisma) and this is where its hosted https://p-hammed-blogr-nextjs-prisma.vercel.app/ Thanks in advance.

Hey Taylor 👋 How exactly have you configured tracing? Is this happening on the latest Prisma version? Just to confirm, are you following this guide? https://www.prisma.io/docs/concepts/components/prisma-client/opentelemetry-tracing#visualize-traces-with-jaeger

Hey, I have a question regarding the $transaction API. Let's presume there is two sequential queries wrapped like following

const [queryOne, queryTwo] = await prisma.$transaction([])

The transaction will fail if one of them fails but what happens if one of them succeed and the other fails? Will the query that succeeded actually run towards the DB even though the other query failed?

Hey folks, just wanted to let you know the exported type

PrismaAction

referenced by

MiddlewareParams

is missing the new new

findFirstOrThrow

and

findUniqueOrThrow

actions from the 4.0 release. Easy enough for us to patch with TS unions but thought you'd want it on your radar 🙌

Hello, is there a channel for questions around Prisma and implementation in projects?

i have this error even if credentials are correct

{ "errors": [ { "message": "Unexpected error.", "locations": [ { "line": 2, "column": 3 } ], "path": [ "users" ], "extensions": { "originalError": { "message": "\nInvalid

prisma.user.findMany()

invocation:\n\n\nAuthentication failed against database server at

localhost

, the provided database credentials for

root

are not valid.\n\nPlease make sure to provide valid database credentials for the database server at

localhost

.", "stack": "Error: \nInvalid

prisma.user.findMany()

invocation:\n\n\nAuthentication failed against database server at

localhost

, the provided database credentials for

root

are not valid.\n\nPlease make sure to provide valid database credentials for the database server at

localhost

.\n at RequestHandler.handleRequestError (D:\\prisma\\es-app\\node_modules\\@prisma\\client\\runtime\\index.js2991513)\n at RequestHandler.request (D:\\prisma\\es-app\\node_modules\\@prisma\\client\\runtime\\index.js2989212)\n at async PrismaClient._request (D:\\prisma\\es-app\\node_modules\\@prisma\\client\\runtime\\index.js3086416)\n at async Object.users (webpack-internal:///(api)/./pages/api/graphql.ts7828)\n at async Promise.all (index 0)\n at async file///D/prisma/es-app/node_modules/@envelop/core/esm/orchestrator.js37727\n at async processRequest (file///D/prisma/es-app/node_modules/@graphql-yoga/common/esm/processRequest.js2320)\n at async YogaNodeServer.getResponse (file///D/prisma/es-app/node_modules/@graphql-yoga/common/esm/server.js31328)\n at async YogaNodeServer.YogaServer.handleRequest (file///D/prisma/es-app/node_modules/@graphql-yoga/common/esm/server.js6930)\n at async YogaNodeServer.handleIncomingMessage (file///D/prisma/es-app/node_modules/@graphql-yoga/node/esm/index.js5326)" } } } ], "data": null }

This message was deleted.

Hi, starting new job today and having an issue with ubuntu 22.04 and prisma v2.27. I can't very well tell them they have to upgrade before I even get the code running on dayone. So I need to work this around. can some one give a hand?

Hey guys, sorry to be that guy that joins and asks a question immediately but I need some help with deploying Prisma on Firebase Functions but I believe I'm getting an error because

PrismaClient

is not being generated. I've tried searching online and added this

postinstall

script in my

package.json

that does a

yarn prisma generate

but I'm lost at how that all works. For context -- I'm using Firebase Functions to schedule regular updates to update the database (Planetscale) and add new rows/prune old ones. Not sure if the error message helps but here's what Firebase Functions returned.

Hi - I am trying to implement cursor based pagination. (docs here - https://www.prisma.io/docs/concepts/components/prisma-client/pagination) . how do I know I have reached the last batch available? my "isLoading" spinner just keeps spinning and no exception is being thrown.

Hello! Would someone be able to provide me an example of adding a second schema Prisma using prisma-util? For example, I would like access to this table public.table1 and access to schema2.table1 by adding the correct settings in prisma-util.config.json. Currently the connection I have setup only has access to the database's public schema and I need to access other schemas. Thanks!

I have a many-to-many relationship between jobs and locations. I first seed the locations and then when seeding the jobs I am trying to connect them with some locations like this

locations: { connect: [{ id: 1 }, { id: 2 }] },

but it is not connecting the jobs with locations. any ideas what I am doing wrong?

do i ask my questions here? i asked mine in #mongodb but not sure if thats the right place

Hi community, I’m trying to deploy an application with prisma and expressJs on a Freebsd server and its said that needs binaries when try to get them it’s said that binaries were not found… anyone knows?

if i got a prisma field like this:

roleIds: String[]

How can I delete 1 value from many users?

await prisma.serverMember.updateMany({where: {roleIds: {has: roleId}}, data: {
  roleIds: // what goes here?
}});