[GH-ISSUE #38] npm run db:push didn't work, This is how I resolved #38

New issue

Open

opened 2026-02-27 10:17:08 +03:00 by kerem · 2 comments

kerem commented

2026-02-27 10:17:08 +03:00

Owner

Originally created by @KelumPerera on GitHub (Sep 29, 2024).
Original GitHub issue: https://github.com/mendsalbert/ai-finance-tracking/issues/38

To solve the above I updated dbConfig.jsx and drizzle.config.js as follows

import {neon} from "@neondatabase/serverless"
import {drizzle} from "drizzle-orm/neon-http"
import * as schema from "./schema"
import { cwd } from 'node:process';
import { loadEnvConfig } from '@next/env';

loadEnvConfig(cwd());


const sql = neon(
    process.env.NEXT_PUBLIC_DATABASE_URL 
)

export const db = drizzle(sql, {schema});

import { cwd } from 'node:process';
import { loadEnvConfig } from '@next/env';
loadEnvConfig(cwd());

export default {
    dialect: "postgresql",
    schema: "./utils/schema.jsx",
    out: "./drizzle",
    dbCredentials: {
        url: process.env.NEXT_PUBLIC_DATABASE_URL,
        connectionString: process.env.NEXT_PUBLIC_DATABASE_URL,
    },
};

I hope this helps!
Thanks to @shmshd https://github.com/drizzle-team/drizzle-orm/issues/654#issuecomment-1681676563

Originally created by @KelumPerera on GitHub (Sep 29, 2024). Original GitHub issue: https://github.com/mendsalbert/ai-finance-tracking/issues/38 To solve the above I updated dbConfig.jsx and drizzle.config.js as follows ``` import {neon} from "@neondatabase/serverless" import {drizzle} from "drizzle-orm/neon-http" import * as schema from "./schema" import { cwd } from 'node:process'; import { loadEnvConfig } from '@next/env'; loadEnvConfig(cwd()); const sql = neon( process.env.NEXT_PUBLIC_DATABASE_URL ) export const db = drizzle(sql, {schema}); ``` ``` import { cwd } from 'node:process'; import { loadEnvConfig } from '@next/env'; loadEnvConfig(cwd()); export default { dialect: "postgresql", schema: "./utils/schema.jsx", out: "./drizzle", dbCredentials: { url: process.env.NEXT_PUBLIC_DATABASE_URL, connectionString: process.env.NEXT_PUBLIC_DATABASE_URL, }, }; ``` I hope this helps! Thanks to @shmshd https://github.com/drizzle-team/drizzle-orm/issues/654#issuecomment-1681676563

kerem commented

2026-02-27 10:17:09 +03:00

Author

Owner

@ResanduUthsara commented on GitHub (Jan 15, 2025):

Which one is drizzle.config.js

@ResanduUthsara commented on GitHub (Jan 15, 2025): Which one is drizzle.config.js

kerem commented

2026-02-27 10:17:09 +03:00

Author

Owner

@ResanduUthsara commented on GitHub (Jan 16, 2025):

Which one is drizzle.config.js

@ResanduUthsara commented on GitHub (Jan 16, 2025): Which one is drizzle.config.js

No labels

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/ai-finance-tracking-mendsalbert#38

No description provided.

Rows
Columns