Accelerate w/o ORM questions
Hey - so after going bacfk & forth between drizzle/neon & prisma orm/prisma pg, I've decided to try drizzle + prisma postgres combo.
I love the prisma orm but its 100x faster to get type safe & validated API endpoints up & running with drizzle & zod. (prisma's 3rd party zod generator no longer works).
That said, I do prefer parts of prisma's DX like the prisma dev cli + local DB instances & prisma studio over drizzle studio or neon local proxy.
I've managed to get my local & remote prisma postgres instances working with drizzle using the pg adapter.
But it only works with the direct connection string (remote) and tcp connection (in local dev).
So I wanted to know - how does using alternate orms with prisma postgres impact Accelerate features?
I'm assuming I lose out on query optimization but what about connection pooling?
If Accelerate only works with prisma's orm, can you direct me to any resources that explain the best way to manage connection pooling with prisma postgres if not using your orm.
Hope all this makes sense!
3 Replies
You selected the carefully hand-crafted route. A dev artisan will respond soon. Meanwhile, the
#ask-ai channel awaits if you're curious!AFAIK Accelerate is Prisma ORM only. Maybe try something equivalent like Cloudflare’s Hyperdrive? https://developers.cloudflare.com/hyperdrive/get-started/
Cloudflare Docs
Getting started
Hyperdrive accelerates access to your existing databases from Cloudflare Workers, making even single-region databases feel globally distributed.
I'm assuming I lose out on query optimization but what about connection pooling?If you are use Prisma Postgres with Drizzle, you would need to use the Direct connection string as you are currently using. At the moment, there are no connection pooling benefits with this direct connection string, however we are planning to add connection pooling soon.