Dhwanik Panchal
05/23/2022, 5:52 PMprisma.schema
file for data modelling. Let's suppose. the application grows and so do the number of database tables. Since all the models will be in one schema file does it impact performance in any way?
2. Related to previous question, can we separate models in prisma.schema
file across multiple "schemas"?
Thanks!Mathie
05/23/2022, 9:44 PMNilay Kothari
05/24/2022, 2:20 AMBlair
05/24/2022, 4:02 AMusers: N patients: N referrals: N referral_notes
• User has many patient records
• Patient records have many referrals
• Referrals have many referral_notes
I need to enforce rules similar to these:
• A user
may be granted access to a referral
through their patient
record.
• A user
may be granted access to a referral
explicitly via a record in another table (permissions
table)
• Whenever a user has access to a referral
, they automatically have access to view referral_notes
I have tried to use graphql-guard
with prisma as a POC, but not sure if this is the correct combination of tools for this use case.
Any help would be hugely appreciated. 🙏Brothak
05/24/2022, 6:05 AMNima
05/24/2022, 9:46 AMMark Hovsepyan
05/24/2022, 12:44 PMtime
in orderBy.transactions.time`Mark Hovsepyan
05/24/2022, 12:45 PMJason Kleinberg
05/24/2022, 12:51 PMSlackbot
05/24/2022, 1:32 PMuser
05/24/2022, 1:40 PMBerian Chaiwa
05/24/2022, 2:11 PM// Timestamps
created_at DateTime @default(now()) @db.Timestamptz()
created_by String
last_modified_at DateTime @updatedAt @db.Timestamptz()
last_modified_by String
Moaaz
05/24/2022, 2:16 PM500
pgbouncer defaultPoolSize
is 700
, with maxClientConn
set to 10000
Trying to understand, what order of connections seems to be normal for a medium scale use of the Prisma API. We have on the order of 1000s of users making requests at the same time.Tharshan
05/24/2022, 2:49 PMBerian Chaiwa
05/24/2022, 4:01 PMError: Could not resolve @prisma/client despite the installation that we just tried.
Please try to install it by hand with yarn add @prisma/client and rerun yarn prisma generate 🙏.
Rahul Taing
05/24/2022, 5:34 PMJason Kleinberg
05/24/2022, 6:53 PMRichard Ward
05/24/2022, 7:11 PMSteven Kuck
05/24/2022, 8:17 PMprisma db pull --schema <our schema file with connection string>
it connects and sees the database tables and works. When we try to start up the app (which runs fine against local copies of the database) with the same connection string we get error logs of
UnhandledPromiseRejectionWarning: Error: Can't reach database server at `<our.rds.instance>.<http://rds.amazonaws.com|rds.amazonaws.com>`:`3600`
This is the format of our connection string.
mysql://<user>:<pass>@<our.rds.instance>.<http://rds.amazonaws.com:3306/<database>?pool_timeout=10&connect_timeout=10&sslcert=<ourcert.pem|rds.amazonaws.com:3306/<database>?pool_timeout=10&connect_timeout=10&sslcert=<ourcert.pem>>
Could not having a public IP be causing a connection issue in the Rust code?
It's not even getting to the "Authentication failed" which is what happens if I leave off the sslcert when doing a db pull.Kelly Copley
05/25/2022, 1:47 AMMatt O
05/25/2022, 2:47 AMBrothak
05/25/2022, 8:20 AMBrothak
05/25/2022, 8:24 AMBrothak
05/25/2022, 8:24 AMBrothak
05/25/2022, 8:26 AMMathie
05/25/2022, 9:50 AMAndrea
05/25/2022, 11:33 AMprisma migrate
. The command has as output "`Generated Prisma Client (3.14.0 | library) to ./node_modules/@prisma/client in ....`".
My question is the following: does prisma migrate, update only the db or also the filesystem? If it also updates the filesystem, are the changes negligible or at the start of each container do I have to migrate first so that it updates the filesystem?Austin Zentz
05/25/2022, 1:34 PMColin OBrien
05/25/2022, 2:54 PMColin OBrien
05/25/2022, 2:55 PM