Hi, I love Prisma & have been using it for a w...
# orm-help
y
Hi, I love Prisma & have been using it for a while! I am switching from PostgreSQL to Cockroach DB (seamless thanks to Prisma!!) & wanted to know if the configuration is different. Specifically do I require the data proxy: https://www.prisma.io/data-platform/proxy. Since CockroachDB has Serverless features do I require the proxy. With PostgreSQL I can understand why I would need it. Would love thoughts on this
1
j
I might be wrong but the proxy is more for if your applications are serverless not so much the database. we use cockroachdb (not cockroachdb serverless) just fine without the data proxy. The data proxy is a tool to manage stateful connections to serverless apps
y
Thanks for the reply! My application will be serverless. Hosting GraphQL on Cloudflare Workers
So how I see it (correct me if I am wrong please), is that the endpoint manages all the connection pooling for us & keeps them open for any queries. It's an abstraction for the connection. CockroachDB has Serverless architecture so do I need that is kind of my question?
j
The prisma team might be better suited to handle the benefits of their data proxy. You would be able to use prisma in. a serverless app without the data proxy, however you would have to be careful of scaling limits on your workers and managing the connection pool yourself.
👋 1
❤️ 1
y
Sure, thanks for the conversation 🙂
n
Thanks for chiming in Jared 🙌 And Welcome to our community Yudhvir 👋 I didn’t see this conversation earlier so replied in this thread: https://prisma.slack.com/archives/CA491RJH0/p1664175073909419?thread_ts=1664158285.063329&cid=CA491RJH0 TLDR: As Jared mentioned it isn’t necessary for you to use data proxy, but you would need to take care of connection pooling, By using data proxy we take care of connection pooling and scaling you database connections as your app experiences high traffic. If you try out data proxy, we would love to hear your feedback 😄