How do I specify username, password, db host, and ...
# orm-helpn
Noel Martin Llevares
11/21/2021, 1:14 AMHow do I specify username, password, db host, and db name individually instead of one DATABASE_URL?
Copy code
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}j
Jawad Sefiani
11/21/2021, 1:29 PMTake a look at this section: https://www.prisma.io/docs/guides/development-environment/environment-variables#expanding-variables
n
Noel Martin Llevares
11/21/2021, 8:22 PMYup. Nothing helpful there.
Noel Martin Llevares
11/21/2021, 8:24 PMWhat I wish to use is something like this:
Copy code
datasource db {
provider = "postgresql"
username = env("DATABASE_USER")
{{ ...more properties like password, host, port, db_name }}
}j
Jawad Sefiani
11/21/2021, 11:04 PMWhy would you wanna do something like that?
n
Noel Martin Llevares
11/21/2021, 11:51 PMMost database libraries accept those aside from just the connection string.
My credentials are stored as individual secrets. To use it with Prisma, I still have to concatenate them into one connection string.
Noel Martin Llevares
11/22/2021, 12:12 AMAn alternative would be for Prisma to support concatenating them.
Copy code
datasource db {
provider = "postgresql"
url = "postgres://" + env("DATABASE_USER") + ":" + env("DATABASE_PASSWORD") + ...
}r
Ryan
11/22/2021, 5:32 AM@Noel Martin Llevares 👋
This isn’t possible at the moment, you need to pass the entire URL directly.
n
Noel Martin Llevares
11/22/2021, 6:09 AMThanks @Ryan
👍 1
2 Views