Which db provider for Edge connection with transactions
Hi! I'm trying to figure out which postgres client to use for edge compatibility in my Next.js app. I'm currently running on Vercel Node runtime, but working on migrating my app over to the edge runtime. I'm currently using supabase (as vanilla postgres), but I'm having issues getting the serverless edge compatible connection to work. I looked at neon, but looks like the serverless driver does not support transactions. I need support for transactions since I'm using them extensively with Drizzle.
Current setup:
- Next.js app using edge runtime
- Drizzle ORM with postgres-js
- Running Postgres locally in Docker
- Using transactions for data consistency
I'd appreciate any guidance on which client would be the best fit for edge compatibility while maintaining transaction support. Has anyone successfully migrated a similar setup to edge runtime?
Thanks!
1 Reply
On Supabase, are you using the right type of connection string?