Missing_Connection_string VercelPostgresError
Unanswered
Nile Crocodile posted this in #help-forum
Nile CrocodileOP
Hi I'm trying to use VercelPostgres locally aswell as your supposed to be able to but something is going wrong. It appears next/vercel is not picking up my .env variables. In detail the POSTGRES_URL variable.
I have a envConfig.ts
"use server"
import { loadEnvConfig } from '@next/env';
const projectDir = process.cwd();
loadEnvConfig(projectDir);
I have in my drizzle.config.ts
import '../../envConfig';
import { defineConfig } from "drizzle-kit"
export default defineConfig ({
out: "./drizzle",
schema: "./src/server/db/schema.ts",
dialect: "postgresql",
dbCredentials: {
url: process.env.POSTGRESURL!,
},
tablesFilter: ["goldencars*"],
})
And my src/server/db/index.ts
import { sql } from '@vercel/postgres';
import { drizzle } from 'drizzle-orm/vercel-postgres';
import * as schema from './schema'
import '../../envConfig';
// Debug environment variables
console.log('Database Environment:', {
url: process.env.POSTGRES_URL,
nodeEnv: process.env.NODE_ENV,
});
export const db = drizzle(sql, { schema });
I need help pls!
I have a envConfig.ts
"use server"
import { loadEnvConfig } from '@next/env';
const projectDir = process.cwd();
loadEnvConfig(projectDir);
I have in my drizzle.config.ts
import '../../envConfig';
import { defineConfig } from "drizzle-kit"
export default defineConfig ({
out: "./drizzle",
schema: "./src/server/db/schema.ts",
dialect: "postgresql",
dbCredentials: {
url: process.env.POSTGRESURL!,
},
tablesFilter: ["goldencars*"],
})
And my src/server/db/index.ts
import { sql } from '@vercel/postgres';
import { drizzle } from 'drizzle-orm/vercel-postgres';
import * as schema from './schema'
import '../../envConfig';
// Debug environment variables
console.log('Database Environment:', {
url: process.env.POSTGRES_URL,
nodeEnv: process.env.NODE_ENV,
});
export const db = drizzle(sql, { schema });
I need help pls!