Using the Prisma Data Proxy with Vercel, Prisma, Next.js, and PostgreSQL
https://www.youtube.com/watch?v=iyGZ8JFPgoY▾
In this video, you will learn about how the Early Access version of the Prisma Data Proxy solves database connection management in serverless environments.
The Prisma Data Proxy is an external connection pooler that sits between your app and your database so you can reliably use relational databases in serverless environments.
In the video, Daniel deploys a Next.js app built with Prisma and PostgreSQL to Vercel and runs a load test to show the database connection limit exhausted. He then imports the project to the Prisma Data Platform and configures the Prisma Data Proxy to eliminate database connection exhaustion.
Timestamps:
00:00 - 1:40 The connection pooling problem in serverless environments
1:40 - 5:16 A look at the demo built using Next.js and Prisma
5:16 - 6:16 Deploying the application to Vercel without using the Data Proxy
6:16 - 8:12 Load testing to demonstrate the connection pooling problem using K6
8:12 - 12:20 A look at the Prisma Data Platform and setting up the Data proxy
12:20 - 17:29 Updating the Next.js demo project to use the Data Proxy
17:29 - 18:56 Adding the Data Proxy connection string to the project on Vercel
18:56 - 21:23 Setting to the Vercel build command to run migrations in builds
21:23 - 24:06 Running the load test with the Data Proxy and comparing the results
24:06 - 27:30 Summary