using a env var for a database

[chrisdrackett]

pre-nexus we had the following in our schema.prisma:

datasource postgresql {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

this does not seem to work with nexus using a .env file. If I replace it with the actual URL it works.

The error I get is:

Error creating a database connection.

I'm going to keep digging, but was curious if anyone else has run into this.

[Weakky]

Is your .env file next to your prisma.schema file? Because it needs to be. AFAIK it's currently a limitation of the Prisma CLI

[chrisdrackett]

So this ended up being the following code in our server:

process.env.DATABASE_URL = `${process.env.DATABASE_URL}?connection_limit=1`

for some reason if we edit this URL like so we run into errors. Luckily as we're (attempting) to move to Heroku we no longer need this line so I just removed it and the error went away