Anyone know when the next series is going to be added? 😮 https://www.prisma.io/blog/fullstack-nextjs-graphql-prisma-oklidw1rhw

Hi, team I am working (currently working on design) on a FOSS side project multi-tenant application where each tenant is given a separate Postgres database. Let's assume the following are database connection URLs. Tenant Foo: postgres://postgres:PASS@localhost:5432/ten_foo/ Tenant Bar: postgres://postgres:PASS@localhost:5432/ten_bar/ Requirement 1: Now, whenever a user asks for a resource. I first call a "Tenant Context Service" to get the database URL. Now I want to use it to fetch the data. Shall I dynamically change the data source (as shown in https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#datasources)? Will it have any performance impact, considering that I want to use connection pooling? Requirement 2: I have a total of 24 relations. And every tenant shares the same set of relations except one. In one relation (or table) namely UserProfile, the tenant can customize the columns. (For example: Say tenant A wants UserProfile to have "Name", "Age", "Years of Experience" and tenant B wants UserProfile to have ("First Name", "Last Name", "Age")).

Note: There is another table to store the metadata like Age is a number, First Name is a String. And all these things are enforced by triggers etc. In other words, for every column in UserProfile (say first_name) I have another table (say UserProfileFields) where I store the meta information on "first_name". Whenever a new row is added/edited to UserProfileFields corresponding changes are reflected in UserProfile column using row level triggers.

Should I still use Prisma, considering the variable nature of the schema of UserProfile relation? I am new to system design etc, and I apologise for any silly design flaws. I would be very grateful if I could get any inputs. Thank you.

I noticed prisma didn't generate all the different types for my models after the first Model I created (I am using JavaScript). The first Model I created was called User, and when I saw the intellisense on

prisma.user

I was impressed, I have gone on to create 9 more models after this and the only thing it suggests is the other model names

await prisma.modelname

, after this there's no types again once you start using

create

,

findMany

..e.t.c When I hover my mouse over , it just shows type

any

Can someone please help me out on how to fix this, it prevents me from making some errors as I know what method and properties are safe to use

how do I access the type of a specific model? E.g. I am getting a user collection passed via props (nextjs), how do I specify the type of it?

Hello everyone I'am a backend engineering enthusiast and liked the concept of prisma

my questions is : is there a students related mentorship and internship programs at prisma ? cause the opportunities i saw are mostly senior related ?

Hi

Hi Prisma team. Will there be any support for Cassandra in future?

This message was deleted.

can I have a generic mutation that deletes a resource? something like

_await_ ctx.prisma?.[resourceType].delete()…

typescript doesn’t like it

i'm trying to run some cypress tests on a next.js app using prisma. i'd like to run a prisma seed file before the tests run, so i can be sure there is predictable test data in the db. in

/cypress/plugins/index.js

i have:

const seedDb = require("../../prisma/seed.js")

module.exports = on => {
  on("task", {
    resetDb: async () => {
      await seedDb()
      return true
    },
  })
}

which works fine, but my prisma seed file can't find the database url: 😞

const { PrismaClient } = require("@prisma/client")
const prisma = new PrismaClient()

const main = async () => {
  // make stuff here
}

main()
  .catch(e => {
    console.error(e)
    process.exit(1)
  })
  .finally(async () => {
    await prisma.$disconnect()
  })

module.exports = main

i'm invoking it using a command like this in my npm scripts, like the docs suggest

"cypress": "dotenv -e .env.test next dev & cypress open",

and i have a

.env.test

file defined with a working

DATABASE_URL

string. what am i doing wrong?

Setting up a PostgreSQL database Blog Post: https://www.prisma.io/blog/fullstack-nextjs-graphql-prisma-oklidw1rhw Code: https://github.com/m-abdelwahab/awesome-links Learn more about Prisma: ◭ Website: https://www.prisma.io​​​ ◭ Docs: https://www.prisma.io/docs​​​ ◭ Quickstart: https://www.prisma.io/docs/getting-started/quickstart-typescript

I just found out why my typescript autocomplete was so slow all the time. When you setup prisma like following https://www.prisma.io/docs/guides/performance-and-optimization/connection-management#prevent-hot-reloading-from-cre[…]-new-instances-of-prismaclient Typescript gets barely useable. I replaced it with basic

export const prisma = new PrismaClient();

and all performance issues were resolved. Should I create a ticket for that?

Hi Guys, how can I get all rows including specific word in one column. Example: column_name(varchar): "This is just a test", return if column_name includes "test"

Hello. I have a field with

Json

but when I try to write data to it I get the following error:

Type 'OrderOutput[]' is not assignable to type 'InputJsonValue'.

I thought Json should be able to take any valid json. Pasting the interface in the thread 👉

Prisma Meetup Korea Prisma Meetup Korea is an online event aiming to connect, inform and empower the Korean developers. Join with other local engineers to discuss the latest database and API developments and learn more about Prisma best practices. This event has been created in cooperation with dooboolab (https://dooboolab.com) - an IT agency based in Seoul. Speakers: ◭ Hyo Chan Jang ◭ Han Sangjin ◭ Jed Watson 🇰🇷 데이터베이스의 best practice, 프리즈마의 동작원리, 프로덕션 레벨에서의 프리즈마 예제 등 프리즈마에 대해 좀 더 알고자 하시는 분은 각 지역의 프리즈마 엔지니어링 커뮤니티에 참여하세요. 이번 밋업에서 3명의 발표자 분들이 있으십니다. 한상진 : Wonderwall 백엔드 개발자 장효찬 : dooboolab founder Jed Watson : The Thinkmill co-founder, KeystoneJs 제작자 Meetup Group: https://www.meetup.com/prisma-meetup-korea/ 🎁 이벤트 기간동안 추첨을 진행합니다. 놀라운 선물들을 얻을 기회를 놓치지 마세요. 우리는 베를린 코드 컨벤션을 따릅니다. https://berlincodeofconduct.org/ Learn more about Prisma: ◭ Website: https://www.prisma.io​​​ ◭ Docs: https://www.prisma.io/docs​​​ ◭ Quickstart: https://www.prisma.io/docs/getting-started/quickstart-typescript

What does this error mean?

Foreign key constraint failed on the field:

Print_userId_fkey (index)

I tried googling but I couldn't find any good explanation. Is it because some tables have Int as id while others have String?

Why closed captions and how easy is to add them to your video Adding close captions to your YouTube videos is a small inclusive step that can have a significant impact for a large portion of your audience. In this video, Nika Musić covers why adding closed captions is important and how it can benefit you. Prisma sponsors high-quality, human-reviewed, professional closed captions for ANY video that benefits our community (for example, Node.js, TypeScript & Type Safety, Prisma, databases, etc.). Learn more and get your FREE captions here: https://pris.ly/closedcaptions 0:38 - Benefits of closed captions: 1️⃣ Wider Audience 2️⃣ SEO Benefits 3️⃣ Higher view time and engagement 4️⃣ Mitigated audio issues ------------------------ 📚 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

I have the following model in my schema with CASCADE set:

model Solve {
  user   User @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId Int

  challenge   Challenge @relation(fields: [challengeId], references: [id], onDelete: Cascade)
  challengeId Int

  createdAt DateTime @default(now()) @map(name: "created_at")

  @@id([userId, challengeId])
}

Now when I am trying to delete a user with

prisma.user.delete({where:...})

, I get the following error: `The change you are trying to make would violate the required relation 'SolveToUser' between the

Solve

and

User

models.`

Why is that? I thought the cascade will take care of this.

hello, is it possible to say that a field can be 1 or more relations? example

referenceId Int

========
model A

model B

model C

how can I say that

referenceId

can be either

A

,

B

or

C

I have the following model (which was suggested by next-auth):

model Account {
  id                 Int       @default(autoincrement()) @id
  compoundId         String    @unique @map(name: "compound_id")
  userId             Int       @map(name: "user_id")
  providerType       String    @map(name: "provider_type")
  providerId         String    @map(name: "provider_id")
  providerAccountId  String    @map(name: "provider_account_id")
  refreshToken       String?   @map(name: "refresh_token")
  accessToken        String?   @map(name: "access_token")
  accessTokenExpires DateTime? @map(name: "access_token_expires")
  createdAt          DateTime  @default(now()) @map(name: "created_at")
  updatedAt          DateTime  @default(now()) @map(name: "updated_at")

  @@index([providerAccountId], name: "providerAccountId")
  @@index([providerId], name: "providerId")
  @@index([userId], name: "userId")

  @@map(name: "accounts")
}

How do I delete an entry by specifing a userId now? I tried this

await prisma.account.delete({
    where: {
      userId: userId,
    },
  });

which results in

Type '{ userId: number; }' is not assignable to type 'AccountWhereUniqueInput'.

Can someone welcome me?

For prisma1 on version 1.34.12, the

npx prisma1 introspect

and

npx prisma1 init

both do nothing. I’m using all the correct database connection data (these same connection data work perfectly when using psql to connect). I’m running these both from the same folder where I use

npx prisma1 deploy

successfully daily. When the interactive cli data entry tool reaches the last question (the ssl question) it just seems to quit, return to the cli and leaves no errors, no output and no introspected datamodel file. Any ideas?

Are the createdAt and updatedAt fields required in the data model for datamodel v1.1. In v1.0 they were implicitly available but hidden, when queried. Now when updating to the new datamodel v1.1 the prisma deploy output warns it will delete (and cause data loss) all createdAt and updatedAt fields from the database because they are not explicitly in the datamodel. In order to not lose data, do I need to add createdAt and updatedAt to every single type in my data model explicitly now with v1.1?

Can i get clarification regarding the @Prisma/client and prisma Prisma aka prisma/cli is a dev dependency and is not required in production When running it inside a docker container without prisma/cli and without running prisma generate first i get this error

Error: @prisma/client did not initialize yet. Please run \"prisma generate\" and try to import it again.\nIn case this error is unexpected for you, please report it in <https://github.com/prisma/prisma/issues>\n at new PrismaClient (/usr/app/node_modules/.prisma/client/index.js:3:11)\n at /usr/app/main.js:28701:20\n at Plugin.exec (/usr/app/node_modules/avvio/plugin.js:132:19)\n at Boot.loadPlugin (/usr/app/node_modules/avvio/plugin.js:267:10)\n at Task.release (/usr/app/node_modules/fastq/queue.js:149:16)\n at worked (/usr/app/node_modules/fastq/queue.js:201:10)\n at /usr/app/node_modules/avvio/plugin.js:270:7\n at done (/usr/app/node_modules/avvio/plugin.js:202:5)\n at check (/usr/app/node_modules/avvio/plugin.js:226:9)\n at node:internal/process/task_queues:141:7","type":"Error","msg":"@prisma/client did not initialize yet. Please run \"prisma generate\" and try to import it again.\nIn case this error is unexpected for you, please report it in <https://github.com/prisma/prisma/issues>"}

prisma/cli is required to run prisma generate

If you have

COMMENT ON Table foo is "bla bla"

in PG database. Will prisma pull then use that comment in prisma file like this?:

/// bla bla
model foo {
...
}

Just saw there’s full text search in the latest release of prisma, will this eventually be available for MySQL?