how to seperate dev vs prod db

Hi everyone I have a local dev db and a production db on railway however when ever I use my local dev db I need switch the env variable in my prisma schema to dev instead of prod. How do I have the prod version but continue to work with dev on my local machine

Sybatron•4/3/23, 9:40 AM

https://www.prisma.io/docs/guides/development-environment/environment-variables#example-set-the-database_url-environment-variable-in-an-env-file

Prisma

Environment variables

Learn how to use environment variables in your Prisma project

Sybatron•4/3/23, 9:41 AM

I think this is what you need to look into

Sybatron•4/3/23, 9:43 AM

https://www.prisma.io/docs/guides/development-environment/environment-variables/using-multiple-env-files

Prisma

Using multiple .env files.

Learn how to setup a dedicated testing environment using multiple .env files.

Sybatron•4/3/23, 9:43 AM

Or this

Sybatron•4/3/23, 9:44 AM

Also shouldn't you use local .env for development
And you put your production variables on the host (example setting your environment db url on vercel to be the production one)

Sybatron•4/3/23, 9:45 AM

Or any other service you use for hosting should have environment secrets/variables