hey guys, how do you handle the heroku postgres credential rotation when deploying to vercel for example?
i'm new to prisma and following this guide https://vercel.com/guides/nextjs-prisma-postgres but there is no section about the automatic rotation by heroku and how to deal with it
m
Mahmoud
07/31/2021, 6:25 PM
Hey Phil 👋🏼
So after doing a little bit of research here’s what I found:
• Heroku’s secrets need to be manually rotated (either from the UI or CLI), so that means you will need to update the database url from the settings
• For Vercel to automatically update a secret, it needs an integration.
So far, there isn’t one for Heroku Postgres, however, there is an integration for Supabase.
We have an article on how to use the Postgres database provided by Supabase with Prisma: https://dev.to/prisma/set-up-a-free-postgresql-database-on-supabase-to-use-with-prisma-3pk6
I haven’t tried the integration myself, but it should work :)