Hey guys is there a way in prisma where we can get to switch between database URLs ,I find it hard trying to switch between various databases as it would require me rewriting my database url in the schema file each time

Hi dudes

Is there a way that we can set an expiry time on a DB entry for Prisma with MongoDB connection?

Hey guys, what does the prisma schema look like for a situation where two users are friends? This is essentially a many to many relationship but with the table on itself. I'm very confused.

Anyone have experience with Google Compute Engine and Prisma1? I can't access the Prisma Server; supposedly they disable portmapping and docker containers run in host mode, but I can't access the Prisma Server using localhost

Hi guys. I gave it a shot with primsa and nestjs and created the following scheme, used the experimental migrate feature to push it up to the postgres db

model Items {
  id    String  @id @default(uuid())
  title String?
}

However the id in the table doesn't have a default value of

uuid()

, am I missing something here?

I'm about to setup a new project where we are going to use Prisma in favor of TypeOrm. However, the

migrate

function is still in an experimental state, but is there a big risk of using it anyways?

have most people shifted to prisma2?

I want to contact the developers of the website howtographql.com. Where and How do I contact them?

I have a question about prisma 1. Is there a way to query with regxp? I am using mysql as a database

prisma rainbow First Prisma Meetup starts in 20 minutes! fast parrot Tammy Bryant will speak about database horror stories, we also have Hervé Labas’ talk about Prisma’s roadmap and a live interview with Tom Hutchinson, Head of Mobile at Rapha. Hosted by our wonderful Developer Advocate and MC superstar, Daniel Norman. Tune in here: prisma rainbow

Nice to meet you I am a beginner of Prisma 🙂

Our Software Engineer, Carmen Berndt, will give a talk about Prisma (Modern database tools for Node.js and TypeScript) at Node.js Israel Meetup in about 10 minutes! 🙂 You can join in on Zoom here.

Does it make sense to update the DB in the catch block if previous asynchronous code fails? What I’m doing is calling update then a Stripe function. If the call to the Stripe function fails I want to revert the update to the DB.

Hello! Do I remember correctly that the graphql playground for prisma had some sort of a admin view where I could edit data in a table format? Or do I remember something wrongly? 🤔

Hello! I am using Prisma 2 and Apollo server with graphql-code-generator for type safe resolvers. I am having trouble with enum mismatch in the to-be returned Prisma response object.

Type '"PRIVATE"' is not assignable to type 'PrivacyScope'.

Where

enum PrivacyScope

has been defined in the exactly same manner in both Prisma and API schema design. In client, I can see that Prisma uses

makeEnun

. What does it do? Could it be the source os this issue? What's the right way to find and fix this issue? P.S. I can also see that for

enum PrivacyScope { PRIVATE }

Prisma goes the

makeEnum

way whereas graphql-code-generator generates a corresponding

enum

type with key-value like

Private = 'PRIVATE'

Hey team, I have a question. I have a container ( I am using docker compose ) and I would like to connect to the mariaDb using SSL. I can connect without SSL

PRISMA_CONFIG: |
                managementApiSecret: xxxxxxxxx2020
                port: 4466
                databases:
                  default:
                    connector: mysql
                    host: "<http://xxxxx.mariadb.database.azure.com|xxxxx.mariadb.database.azure.com>"
                    port: 3306
                    user: xxxxx@xxxx
                    password: xxxxxxx!

I did not find a parameters for SSL connection on the docker: https://hub.docker.com/r/prismagraphql/prisma This is the instruction from Microsoft: https://docs.microsoft.com/en-us/azure/mariadb/howto-configure-ssl Thank you very much!

Hi all - sorry to post in general but I'm stuck trying to get prisma set up with an AWS RDS postgres database and not sure where the issue is. My next.js app (using prisma client) cannot connect to my RDS database, but prisma studio and

npx prisma migrate save/up

interact with it just fine. It's complaining that authentication failed, but I know it's the correct username and password because I can interact with the database in every environment except in my app (prisma studio, prisma migrate, pgAdmin all work). Any ideas?

Authentication failed against database server at `<postgres-url>`, the provided database credentials for `<user>` are not valid.

Please make sure to provide valid database credentials for the database server at `<postgres-url>`.
    at $w.request (/Users/jh/coprime/hq/node_modules/@prisma/client/runtime/index.js:212:54)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'P1000',
  clientVersion: '2.9.0',
  meta: {
    database_user: 'coprime',
    database_host: '<postgres-url>'
  }
}

Is it possible to use a custom sqlite build when using prisma with sqlite?

https://github.com/graphql-boilerplates/typescript-graphql-server/tree/master/advanced Does anyone know why I can't get the graphql create command to work for this?

Having a problem getting VSCode to pick up a one-to-one relation. I see the relation in the object that the server returns but VSCode is acting like the property doesn’t exist even after running prisma generate.

👋 Join us at week’s events that are featuring or organised by Prisma: • November 2, 4PM CET - NodeConf Remote - Yoshua Wuyts, Software Engineer at Prisma, will give a talk WASM, Rust, and you - sign up to the conference here; • November 5, 7PM CET - GraphQL Mega Meetup + quiz with prizes - Prisma, commercetools and GraphQL London Meetup group join forces to bring you this GraphQL Mega Meetup. During the event you can take part in a quiz and win exciting prizes (lots of swag and tickets to GraphQL Galaxy Conference!) - ; Looking forward to having you there! 🤗

Hi everyone, where’s the best place to discuss

graphql-yoga

? Is it even still maintained?

Can anyone here help me, I want to make a website similar to howtographql.com

can I tell Prisma to transform timestamp columns into Date objects before returning me the queries result?

wait, it seems like it does that by default, but can I customize it for other types?

for an example I want the numeric datatype to be returned as a Decimal.js object

Is it intended that any enums in the Prisma schema file are ignored if they aren’t part of a model? It’d be nice to be able to have them regardless of whether or not they’re being used by a model.

How does one query for relations that don’t exist, i.e. are

null

? For some reason, the following doesn’t work:

await prisma.path.deleteMany({
	where: { AND: [{ Facilitator: { is: null } }, { User: { is: null } }] }
})