Using Vercel Postgres

[taiqn]

Now Vercel has its own Postgres, it would be nice if you could instruct how to implement it

Thanks
Tai

[steven-tey]

Since Dub uses Prisma, you can just swap out the DATABASE_URL env var, change a few of the column formats in the Prisma schema, and it should work!

Closing this for now – hope this helps!

[Danm72]

Hey @steven-tey I'd probably keep this open and maybe make that part of a readme/onboarding I think its a preferred flow to keep a lot of the dependencies in Vercel rather than setting up other subs!

[steven-tey]

@Danm72 good point, converting it into a discussion instead!

[w33ts]

Hey hey! Just a heads up, I did attempt to go down the PostgreSQL route (because I'm cheap and didn't want to pay PlanetScale for another DB), but I ran into this issue here with the @@fulltext part of the Prisma Schema: prisma/prisma#8950

Now, I'm sure there is a workaround or a way to handle it in the code, but I'm not that talented. Hopefully that saves you some time if you add compatibility for PostgreSQL!