DT

Drizzle Team•2y ago

ahylianhuman

drizzle-kit overriding `process.env` before `@next/env` can load values

I'm trying to use drizzle-kit pushdrizzle-kit push using the setup recommended by the Drizzle and Vercel docs, but I am finding that the drizzle-kitdrizzle-kit command is performing its own dotenvdotenv loading before my config file can import and use loadEnvConfigloadEnvConfig from @next/env@next/env. This is causing issues if I have an empty value for POSTGRES_URLPOSTGRES_URL in

.env

.env

(for documentation purposes) and the actual value in .env.local.env.local (for local development) because drizzle-kitdrizzle-kit is unaware of how @next/env@next/env loads environment variables.

I've worked around this issue by setting by setting DOTENV_CONFIG_PATH=/dev/nullDOTENV_CONFIG_PATH=/dev/null, but there should a way to turn this automatic behavior off (or more ideally, make it opt-in instead of opt-out) so it is easier to load environment variables correctly using @next/env@next/env or another

.env

.env

loader of choice.

Drizzle ORM - PostgreSQL

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Using an ORM to access your Postgres database

Learn how to use your favorite ORM to access your database from your apps