Troubles during migrations using drizzle and a neon serverless database
Hello im really new to drizzle and i already learned how to setup a scheme but im having troubles when i want to migrate it to the neon postgressql database.
Error: No database connection string was provided to
Error: No database connection string was provided to
neon()
. Perhaps an environment variable has not been set?
. Perhaps an environment variable has not been set?
This is how my migration file looks like:
import { migrate } from 'drizzle-orm/neon-http/migrator';import { drizzle, NeonHttpDatabase } from 'drizzle-orm/neon-http'import { neon } from '@neondatabase/serverless';async function main() { const sql = neon(process.env.DATABASE_URL as string) const db: NeonHttpDatabase = drizzle(sql); console.log("[migrate] Running migrations ..."); await migrate(db, {migrationsFolder: "lib/db/migrations" }); console.log("[migrate] All migrations have been ran, exiting ...");}main();
import { migrate } from 'drizzle-orm/neon-http/migrator';import { drizzle, NeonHttpDatabase } from 'drizzle-orm/neon-http'import { neon } from '@neondatabase/serverless';async function main() { const sql = neon(process.env.DATABASE_URL as string) const db: NeonHttpDatabase = drizzle(sql); console.log("[migrate] Running migrations ..."); await migrate(db, {migrationsFolder: "lib/db/migrations" }); console.log("[migrate] All migrations have been ran, exiting ...");}main();