https://github.com/prisma/prisma/issues/5304 hi team has the issues with docker install been resolve? @janpio If you have run into this issues what are your work around? I still have this issue when deploy the backend with docker… the node version is 14-alpine The issue happened when I deploy the backend changes in bitbucket pipeline

Not a prisma related question. But I wanted to know what’s the best way to take a backup of a postgres database from Amazon RDS instance?

What's new in Prisma (v2.22.0) starts in 10 minutes! 🤗 Tune in here:

Aaaaand we are moving on to our next livestream of the day - the Prisma Meetup! fast parrot Starting in 10 minutes, here:

I recently wrote an article, building a fullstack jamstack e-commerce app with Prisma and Nextjs: https://joeynimu.com/how-to-build-a-full-stack-jamstack-e-commerce-app-with-nextjs-and-prisma I thought to share on here :-)

Has anyone built a file table, I am curious how you structured it

Hey everyone! What's the easiest way to get Prisma with a postgres on aws running? Should be able to make migrations from github actions... 🙂

Getting this error when trying to add a row in prisma studio

Type: PrismaClientKnownRequestError
Message: The records for relation `MembershipToUser` between the `Membership` and `User` models are not connected.

Code: P2017

Query:
prisma.membership.update(
{
  where: {
    id: 1,
  },
  data: {
    user: {
      connect: [
        {
          id: 1,
        },
      ],
      disconnect: [

      ],
    },
  },
  select: {
    id: true,
    user: true,
  },
}
)

ok, had to adjust both the User row and add a membership row

Hey all I got the following error with prisma when using the disconnect query syntax.

Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState("55000"), message: "cannot delete from table \"_ChangelogEntryToRoadmapItem\" because it does not have a replica identity and publishes deletes", detail: None, hint: Some("To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE."), position: None, where_: Some("SQL statement \"DELETE FROM ONLY \"public\".\"_ChangelogEntryToRoadmapItem\" WHERE $1 OPERATOR(pg_catalog.=) \"B\"\""), schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("execReplication.c"), line: Some(583), routine: Some("CheckCmdReplicaIdentity") }) }) })

Does anyone have any recommendations for Digital Ocean-like services but in one of the regions that Vercel uses (preferably bru1, europe)? I’d like to avoid the horror UI of aws. It’s for hosting a database connected to app deployed on Vercel

Does anyone know why when i try to run

prisma migrate dev

i get:

Error: Prisma Migrate has detected that the environment is non-interactive, which is not supported.

I'm just running these commands on my local machine

nvm, apparently git bash isnt interactive 0_o there goes 3 hours of my time

Hello everyone <!here>! Prisma Day ’21 is coming up! It is a two-day, single track conference focused on databases and application development and it is taking place online on June 29-30. prisma rainbow ⭐️ June 29 will be a workshop day ⭐️ June 30 will be the official Prisma Day with talks and demos Additionally: the Prisma Day CFP is now open. We are accepting submissions until May 23rd. Beginners are welcome just as well as veterans! If you’ve an idea for a talk or something else that you’d like to present - don’t hesitate to get in touch with us. We will help you polish your concept, give you tips and pointers regarding the content, support you throughout the process and do a test run with you before the recording day. 🤝 We have a Slack channel dedicated to Prisma Day that you can join as well: #prismaday Looking forward to seeing you all there! 🤗

Hello all

Are nested writes supposed to be of type any[] when trying to insert multiple related entities?

The very first example here : https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#nested-writes

I believe the

create: [{ title: 'How to make an omelette' }, { title: 'How to eat an omelette' }],

will be of type any[] and autocompletion won’t be available when typing each objects inside the array

I want to be sure about it because maybe we’re doing something wrong

@Julien Goux Seems to work for me, prisma1 and nexus generated types though

Thanks @Lars Ivar Igesund, I’d be interested to know someone who is using Prisma 2 as well like us

Hey! My name is Sam 😄 glad to join the slack!

Hey, I'm stumbling into a problem and I do not know why that may be. I am using a VPS Ubuntu machine from a cheap VPS provider to host and use a database there. I started using Prisma recently and I love its feature set, but after switching from localhost to that remote database I keep having a problem. I am getting the error P1001 when I theoretically shouldn't be. To expand on that, I am trying to run introspect after some changes to the database, but probably due to latency issues, Prisma is not able to reach the database in time. I am certain that the database works properly when used for the actual program because after a small amount of time (30s approximately) the database connects and executes queries properly. I tried adding some connection arguments (specifically

?connect_timeout=30&pool_timeout=30&socket_timeout=30

), but it does not look like it is acknowledging those arguments as I get the error P1001 within 5 seconds of Prisma saying that it is accessing the DB to introspect it. The entire database URL (of course with redacted info) is

<mysql://user:pass@ip:3306/Database?connect_timeout=30&pool_timeout=30&socket_timeout=30>

. Thanks for anyone reading this and thanks in advance for any help 🙏

easiest way to reset the sequence counter for an

@id @default(autoincrement())

field?

How do I get all entries where the id is in a list I pass?

where: { id: [1,2,3] }

fails

(also, `in`is hard to search for)

ok, it was {id: { in: [..]}}

Hello, I am deploying my application to several regions around the world. I noticed that in countries around the world, instead of my requests taking 200ms to respond, they take 2+ seconds. I narrowed down the issue to my db being in the US and the servers being in singapore/germany. Is there anything I can do to improve the query response times and latency? Is there any managed service that distributes my db around the world as well?