is there a way to store `DATABASE URL` in a file instead of Prisma #orm-help

is there a way to store `DATABASE_URL` in a file?...

Alan

08/13/2021, 2:57 AM

is there a way to store

DATABASE_URL

in a file? (instead of

.env

Ryan

08/13/2021, 7:34 AM

@Alan 👋 You can store it as a string in a normal `.js`/`.ts` file and use it like this.

Alan

08/13/2021, 4:45 PM

great thanks! how can I override the

provider

? Thanks!

Ryan

08/13/2021, 6:01 PM

That’s not possible.

Alan

08/15/2021, 1:36 AM

I see. thanks

Alan

08/15/2021, 1:38 AM

If I run

npx prisma migrate deploy

it will take by default the URL in en

.env

not the one in the code.

Copy code

const prisma = new PrismaClient({
  datasources: {
    db: {
      url: config.URL_DB_LOG,
    },
  },
})

Alan

08/15/2021, 1:39 AM

Ryan

08/16/2021, 5:27 AM

This can only be used in your app. When you want to run CLI commands like

migrate

you would always need to have an

.env

file. Could you explain your use case so that I can suggest something based on what you’re trying to achieve.

Alan

08/16/2021, 5:39 AM

I have many databases, (hence many Prisma schema) in many environments. I need to centralize all the databases access into 1 config file. Using .env files is not a solution..

Ryan

08/16/2021, 7:48 AM

I don’t think this is supported at the moment. The only workaround for now is an

.env

file or injecting environment variables before Prisma’s commands. We have a request for this here and you can check the workarounds from this comment and the ones below.

Alan

08/16/2021, 5:03 PM

I added a comment in the thread https://github.com/prisma/prisma/issues/2443#issuecomment-899662851

💯 1

4 Views

Open in Slack

Previous Next