6 replies

URL_INVALID

The env variables are defined when using

bun run push

bun run push

but not when using

npm run push

npm run push

pnpm run push

pnpm run push

, resulting in

LibsqlError: URL_INVALID: The URL is not in a valid format

LibsqlError: URL_INVALID: The URL is not in a valid format

because url is

undefined?authToken=undefined

undefined?authToken=undefined

export default {
  schema: "./src/db/schema.ts",
  out: "./src/db/migrations",
  driver: "libsql",
  dbCredentials: {
    url: `${process.env.DATABASE_URL}?authToken=${process.env.DATABASE_TOKEN}`,
  },
} satisfies Config

export default {
  schema: "./src/db/schema.ts",
  out: "./src/db/migrations",
  driver: "libsql",
  dbCredentials: {
    url: `${process.env.DATABASE_URL}?authToken=${process.env.DATABASE_TOKEN}`,
  },
} satisfies Config

{
  "scripts": {
    "push": "drizzle-kit push:sqlite"
  },
  // ...
}

{
  "scripts": {
    "push": "drizzle-kit push:sqlite"
  },
  // ...
}

Solution

bun parsed the

.env

.env

file automatically but node does not. You need you use

dotenv

dotenv

or something similar when using pnpm/npm/yarn

Jump to solution

Drizzle Team•3y ago•

6 replies

Dayblox

URL_INVALID

The env variables are defined when using

bun run push

bun run push

but not when using

npm run push

npm run push

pnpm run push

pnpm run push

, resulting in

LibsqlError: URL_INVALID: The URL is not in a valid format

LibsqlError: URL_INVALID: The URL is not in a valid format

because url is

undefined?authToken=undefined

undefined?authToken=undefined

export default {
  schema: "./src/db/schema.ts",
  out: "./src/db/migrations",
  driver: "libsql",
  dbCredentials: {
    url: `${process.env.DATABASE_URL}?authToken=${process.env.DATABASE_TOKEN}`,
  },
} satisfies Config

export default {
  schema: "./src/db/schema.ts",
  out: "./src/db/migrations",
  driver: "libsql",
  dbCredentials: {
    url: `${process.env.DATABASE_URL}?authToken=${process.env.DATABASE_TOKEN}`,
  },
} satisfies Config

{
  "scripts": {
    "push": "drizzle-kit push:sqlite"
  },
  // ...
}

{
  "scripts": {
    "push": "drizzle-kit push:sqlite"
  },
  // ...
}

Solution

bun parsed the

.env

.env

file automatically but node does not. You need you use

dotenv

dotenv

or something similar when using pnpm/npm/yarn

Jump to solution

URL_INVALID

Similar Threads

URL_INVALID

Similar Threads

Similar Threads

Similar Threads