Hello! I’m trying out prisma for my company, got a schema built out that works and can generate the client, but I cant figure out how this is supposed to work for separate services, will each new service we build out need to have a local copy of our

schema.prisma

? if you have, say, 10 different microservices, that want access to your db, how would you synchronize and version the schema across all of them?

Hello here. A quick one: Does this seem to be the correct way to implement this relationship? I am curious about that zero or more piece:

model IndicatorUnit {
  id           String @id @default(uuid()) @db.Uuid
  unit         String @unique
  display_name String @unique
  
  indicators Indicator[]

  @@map("indicator_unit")
}

model Indicator {
  id           String @id @default(uuid()) @db.Uuid
  
  report_type_id String
  indicator_unit_id String
  indicator_unit IndicatorUnit @relation(fields: [indicator_unit_id], references: [id])

  @@map("indicator")
}

any recommendations on how to use prisma to backfill data? a typical scenario we have is that we add a column to a table. All the existing records need to be updated to add a value based on some logic. How can I use prisma to insert those values to the new column on existing records?

is there a way to escape search queries when doing FTS - like if I want to search for literal

"q & a"

and want to escape that to not mean

and

also is this right? dog but not cat?

I defined a tsvector column with

search Unsupported("tsvector")?

and then the GIN index in the migration. when I run migrations though it creates a new migration that tries to drop my GIN indexes. the docs say "You can continue using Prisma Migrate as you were before, it will ignore indexes that it doesn't know about." am I missing a step? also I can't search on my tsvector column; it doesn't appear in my generated schema

also if I do

{ body: { search: "foo bar"} }

I get an error

syntax error in tsquery

- if my search string contains a space it works if I do

query.split(/\s+/).join(" & ")

but that seems goofy

Hey all, got a quick question about data fetching. I have 2 tables, similar but different data. When loading a page I want to load the data from table 1 or table 2 depending on the ID.. is there a way to pass data to

await prisma.X.findUnique

with X being the changing variable. OR, is this a database stucture issue and I need to rethink my design?

Can we add different schemas in prisma

As we can add many models in prisma

My problem is that I want to setup profile in different schema and auth in different

Reworded my question.

I have a idea of a database structure but am unable to get a grasp on the correct layout.

Server_type_1:
- title
- description
- name
- id
- custom thing 1
- custom thing 2 
- custom thing x

Server_type_2:
- title
- description
- name
- id
- custom thing 1
- custom thing 2 
- custom thing x

Currently, using postgresql, I'm not understanding how I could load all these options under one URL with NextJS/Prisma. Since I have to specify a table like

Server_type_1

for example?

Postgres supports this data type

chkpass

which can be handy for storing passwords but I noticed in the Prisma docs that unsupported data types will not be part of the generated client. Does Prisma have a model-level helper to achieve something similar?

are there examples of using prisma client(s) to connect to more than 1 db in one project?

Hi all, I’m using postgres and prisma and trying to create a model for a User that includes an image for their profile. What would the type of the image be in the model? Is it Bytea? I haven’t seen any examples of this.

Hi. This might be silly question, but if you make typescript based API and Frontend (Typescript and some mobiles), will you make a monorepo for API and Frontend, and make another repo for mobile? I’m wondering the best practice for making API type safely.

Hi there, Suppose I want a column in a table to only have int's in the range [0,5], i.e. {0,1,2,3,4,5}, how do I specify that in the prisma schema file? Using this with postgresql. Would use this to implement ratings in my database.

Hello, I get this exception, when I try to perform

nest start -w

I have already tried with deleting and reinstalling the

node_modules

I defined prisma schema

generator client {
  provider      = "prisma-client-js"
  output        = "./generated/client"
}

How to resolve the issue ?

Hi, are there official brand resources (especially logos) for Prisma available somewhere? I’m building an open source project that uses Prisma and would like to use the Prisma logo in the docs.

Hi Guys, I am currently learning and exploring prisma3 for MySQL. I am unable to find relevant docs for prisma support for GraphQL Subscriptions. In V1, it was done via prisma-bindings, however I am not sure about v3.

Hi all, I am trying to use Prisma in my AWS lambda to connect it to the Planetscale DB, on local it works fine but after I deploy I am getting the following error in the lambda console:

"@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>",

I have checked and can see

@prisma/client

in the

./node_modules

not sure what is missing

I am getting an error when trying to delete data that doesn’t exist on db. Is it possible to tell prisma to not throw an error if the requested data doesn’t not exist? I am using mongoDB and

delete

method.

await this.prismaService.task.delete({ where: { name } });

name

field is unique

Hey @here, is it possible to use both SQL and NoSQL (say Postgres and MongoDB) together in Prisma ORM?

How can I make a custom array in Prisma Schema. Eg. an array like this

{ reason: string; moderator: string }[]

for migrating to from Prisma 1 Cloud, is there any way to get prisma 1 export into a mysql database without first spinning up a self hosted prisma 1 server, importing there, then upgrading that to prisma2?

basically, is there any way I can take my Prisma 1 export in NDF/JSON format and convert it to SQL or something?

ahh, I guess if I go in prisma cloud it lets me get my the responses from my queries in json format, is translating that into SQL the best bet?

I see that this is the generated output in y Github actions, any idea?

class PrismaClient {
  constructor() {
    throw new Error(
      `@prisma/client did not initialize yet. Please run "prisma generate" and try to import it again.
In case this error is unexpected for you, please report it in <https://github.com/prisma/prisma/issues>`,
    )
  }
}

module.exports = {
  PrismaClient,
}

Heelo Guys