Has anyone tried out the integration of Next/Prisma/Postgres at scale? What was your experience?
Hi everyone, I had been facing issues using Supabase database in the past with Prisma and Next.js. Hence switched over to Vercel's own partner Neon for the database. We are building a trading platform with thousands of users trading every hour hence we need to make the app really reliable. Has anyone tried this combination at scale yet?
16 Replies
adverse-sapphireOP•12mo ago
Also, what was your prisma setup like?
adverse-sapphireOP•12mo ago
Hi @Mahmoud Is this a common issue? We can upgrade the account to the highest tier possible. But we just don't wanna face the same issue we did with supabase here.
crude-lavender•12mo ago
Hey! Are you running into this issue consistently?
Also, which Prisma version are you using
On paid plans you can prevent the database from being suspended
adverse-sapphireOP•12mo ago
seems to happen every 2/100 times or so
5.21.1
ah, it isn't suspended though
adverse-sapphireOP•12mo ago
this is our prisma setup
crude-lavender•12mo ago
Are your serverless functions configured to be in the same region as your neon database?
adverse-sapphireOP•12mo ago
i'm not certain how to configure that, i set up the db using the vercel dashboard
adverse-sapphireOP•12mo ago
ah yeah
adverse-sapphireOP•12mo ago
its the same region
crude-lavender•12mo ago
Can you share with me your compute endpoint ID? You can find it in the connection string
I would recommend upgrading your plan so that you have access to our support team in case an issue occurs
adverse-sapphireOP•12mo ago
yes, doing this in a few days or so
before launch
ep-summer-breeze-a493r924.us-east-1.aws.neon.tech
this right?adverse-sapphireOP•12mo ago
upgraded as well @Mahmoud
crude-lavender•12mo ago
You shouldn't run into any timeout issues with autosuspension disabled
Feel free to reach out if you have any questions or run into any issues 😄
adverse-sapphireOP•12mo ago
awesome sure
foreign-sapphire•12mo ago
@Kunal Bagaria
In case you continue to run into timeout issues, do share the error screenshots. I am curious if you're receiving a 504: Gateway Timeout?
adverse-sapphireOP•11mo ago
sure, haven't received it yet after making the suspension period to none