hi all, im learning prisma with nextjs and so far im having a blast. im currently using a sqlite database using the following code in my

schema.prisma

file:

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

can this be used is production say if i deploy to vercel, or is it only for development? thanks 🙂

Hey everyone 👋, been exploring Prisma and I’m curious if there is a way for me to annotate a new field with Prisma READ: For example, if we have a simple Post, User, & Like table:

// prisma.schema
Table Post { likes [], ... }

Table User { likes [], ... }

Table Like { userId, postId, ...}

Is there a way for me to create a new

likedByUser

Boolean field (Not part of the Post Schema) like this:

prisma.post.findMany({
  where: {..}
  select: {
    likedByUser: { // New annotated field
       where: { 
         likes: [
           { userId: { equals: 2 } },
         ]
       }
    }
  }
});

Hey guys, I am mutating

process.env.DATABASE_URL

before creating a Prisma client instance like

process.env.DATABASE_URL = ...

but unfortunately this results in

error: Environment variable not found: DATABASE_URL.
  -->  schema.prisma:11
   | 
10 |   provider = "mysql"
11 |   url      = env("DATABASE_URL")
   |

Any idea what I can do?

Hey everyone, I'm encountering a very vexing stack overflow on what looks like a pretty standard

createMany

call. I'm creating 20k user records with

prisma.user.createMany({data: records, skipDuplicates: true})

. Each record looks like

{
    email:'<mailto:Dariana_Cronin@example.net|Dariana_Cronin@example.net>',
    emailVerified:true,
    firstName:'Arnoldo',
    lastName:'Brakus',
    username:'Jabari.Schmeler'
}

This call results in

RangeError: Maximum call stack size exceeded
    at Arg.collectErrors (/mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:34906:14)
    at valueToArg (/mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:35224:47)
    at /mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:35468:17
    at Array.reduce (<anonymous>)
    at objectToArgs (/mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:35445:28)
    at /mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:34989:48
    at Array.reduce (<anonymous>)
    at selectionToFields (/mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:34948:36)
    at makeDocument (/mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:34940:20)
    at PrismaClient._executeRequest (/mnt/32DBD2DF4E5DE24C/work/projects/prisma-test/node_modules/@prisma/client/runtime/index.js:36972:23) {clientVersion: '2.29.0', stack: 'RangeError: Maximum call stack size exceeded
…les/@prisma/client/runtime/index.js:36972:23)', message: 'Maximum call stack size exceeded'}

Has anyone encountered anything like this before?

whats your preferred way of sharing a prisma client in a monorepo with two different apps (api and ui)?

Hii, does anyone know about querying with the session I just made with NextAuth.js?

When creating relational entries should i update() the holder of the one to many releation or make the "childs" and just link the parent?

I’m running into an issue where I’m hitting 20/20 connections on my hobby-dev database, and i’m the only one using the website right now. how can i solve this? i’m using the

prisma.$disconnect()

method on all api endpoints, so i’m confused as to why this is an issue Edit: I read some of the docs, and I set a global

prisma

client, and removed all of the

$disconnect

calls. It still seems to eat up the connections quickly, though.

Hello, any way to specify Prisma to format schema using lowercase field names when running

prisma format

?

Hello, with the latest release that supports groupby, is prisma still OpenCRUD compliant?

Hi. I am considering a stack for a new application. Asking for opinions on Prisma+Apollo+NestJS vs Prisma+Apollo. NestJS offers ways to maintain the schema, Apollo of course, but Prisma offers it too. I want to use migrations. Would NestJS even be a benefit in this case? If I use Prisma to maintain the schema, will that generate a GraphQL schema that NestLS can use? Thanks for any advice.

I just ran a pg_dump on my postgres database of 2.8GB and it took about 15-20 minutes to complete. prisma export takes 11+ hours and it is still not done. Any ideas how and why prisma export would take so long compared to pg_dump?

@inlightmedia Multiple factors at play here. pg_dump is optimized for this. Output format is important too, so it depends on the flags you use on pg_dump. So you might be comparing apples with oranges.

How to add global events to prisma? For example there's an update query in any of the models, do something?

Next.JS Prisma trying seed with latest 3.0.2 updated packages: TSError: ⨯ Unable to compile TypeScript: error TS5023: Unknown compiler option '0'. error TS5023: Unknown compiler option '1'.

Hi, is there a way to use Prisma for querying multiple schemas in Postgres? According to this is not supported out of the box https://github.com/prisma/prisma/issues/1122, but maybe there is a way to use prefixes for the schema?

(without raw query obviously)

Nowadays, almost everyone works in a microservices environment. IMHO Prisma just partially support it. The most common patterns to enable data persistence in microservices: • CQRS + event sourcing • Database per service • Shared database per service The shared database per service is very common, and can be achieved via private table or private schemas. Prisma doesnt support private schemas (as can be seen in this issue https://github.com/prisma/prisma/issues/1122).

Hey!! Is there anybody who can help with this? https://stackoverflow.com/questions/69144924/property-create-does-not-exist-in-prisma-client Asked in the client channel but there doesn’t seem to be much activity there

I’m getting “migration failed” and now it needs to reset the DB? can i revert and avoid resetting the DB?? Edit: this helped

Hello, any resource for more information on Data Model Meta Format (DMMF) and how it works with Prisma?

Hello everyone, I have a little question, I have some default value that I want to seed in production for my app by default, is there a specific process to do it? Or should I just run the seeding script in production? Thanks!

has there ever been discussion about a shorthand for

findUnique

using the primary key?

Hey guys, is there anything in the works for https://github.com/prisma/prisma/issues/5052 ?

has anyone ran into the

getUserByAccount is not a function

error when using the PrismaAdapter with

next-auth

?

We had an issue recently in production, where the connection of prisma seemed to be “down”. We had a burst of activity (50 database connections fired in a split second, leading to this problem, and basically breaking our production app):

Object { message: "Timed out fetching a new connection from the connection pool. (More info: <http://pris.ly/d/connection-pool>, Current connection limit: 5)", locations: […], path: […], … } -

I had to redeploy the container we had our API deployed on to fix this (the database connection stayed down until then). Obviously something is going wrong with our connections on prisma, but I can’t tell since we only have a single

prisma client

we init in a module. Any potential ways of troubleshooting this? Should I do the ill-advised

prisma.$disconnect

?

I have a database from https://portal.azure.com/ and I have DATABASE_URL when try to access it it not work so can do any suggestion

to make generate the schema it not working

GraphQL Berlin Meetup #23 - Stephan Schneider - All you (n)ever wanted to know about Introspection ◭ In this talk, Stephan will cover a couple of aspects about what Schema Introspection is, how it relates to ASTs, how it's utilized to client-side validate queries, provide autocompletion, and how its data is used to generate code. ◭ Stephan Schneider (@zcei_ger) is a backend developer at Contentful. Since 2018 GraphQL is not just an interesting technology for him anymore when he started participating in the company's initial development of their first GraphQL API. He has not stepped back since and constantly plays with new ways to integrate pre-existing data into GraphQL. ◭ This talk has been recorded during GraphQL Berlin Meetup. Join our GraphQL Berlin Meetup group here: https://www.meetup.com/graphql-berlin ------------------------ 📚 Resources: ✅ Subscribe to Prisma: https://www.youtube.com/channel/UCptAHlN1gdwD89tFM3ENb6w?sub_confirmation=1 ✅ Get help from the Prisma Community: https://slack.prisma.io/ ✅ Learn more about Prisma: ◭ Website: https://www.prisma.io ◭ Docs: https://www.prisma.io/docs ◭ Quickstart: https://pris.ly/qstart ------------------------ 💬 Connect with Prisma: Twitter: https://twitter.com/prisma Instagram: https://www.instagram.com/prisma.io/ TikTok: https://www.tiktok.com/@prismadata Facebook: https://www.facebook.com/prisma.io LinkedIn: https://www.linkedin.com/company/prisma-io ------------------------ Prisma sponsors human-reviewed, professional closed captions for ANY video valuable to our community (for example, about: Node.js, TypeScript & Type Safety, Prisma, databases, etc). Get your FREE captions here: https://pris.ly/closedcaptions

GraphQL Berlin Meetup #23 - Max Stoiber - How to edge cache GraphQL APIs ◭ This talk has been recorded during GraphQL Berlin Meetup. Join our GraphQL Berlin Meetup group here: https://www.meetup.com/graphql-berlin ◭ Check out GraphCDN here: https://graphcdn.io/ ------------------------ 📚 Resources: ✅ Subscribe to Prisma: https://www.youtube.com/channel/UCptAHlN1gdwD89tFM3ENb6w?sub_confirmation=1 ✅ Get help from the Prisma Community: https://slack.prisma.io/ ✅ Learn more about Prisma: ◭ Website: https://www.prisma.io ◭ Docs: https://www.prisma.io/docs ◭ Quickstart: https://pris.ly/qstart ------------------------ 💬 Connect with Prisma: Twitter: https://twitter.com/prisma Instagram: https://www.instagram.com/prisma.io/ TikTok: https://www.tiktok.com/@prismadata Facebook: https://www.facebook.com/prisma.io LinkedIn: https://www.linkedin.com/company/prisma-io ------------------------ Prisma sponsors human-reviewed, professional closed captions for ANY video valuable to our community (for example, about: Node.js, TypeScript & Type Safety, Prisma, databases, etc). Get your FREE captions here: https://pris.ly/closedcaptions