Cammy Comments - Answer Overflow

Cammy

Explore posts from servers

DTDrizzle Team BABetter Auth

Posts Comments

BABetter Auth

•Created by Cammy on 1/8/2025 in #help

Using drizzle pglite with better-auth

yeah

8 replies

BABetter Auth

•Created by Cammy on 1/8/2025 in #help

Using drizzle pglite with better-auth

const session = await auth.api.getSession({ headers });

8 replies

BABetter Auth

•Created by Cammy on 1/8/2025 in #help

Using drizzle pglite with better-auth

ah i appreciate that, im currently using tanstack start so it could be an issue with that: but i have the following drizzle-dev.config.ts:

import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./drizzle",
  schema: "./lib/server/schema/index.ts",
  dialect: "postgresql",
  driver: "pglite",
  dbCredentials: {
    url: "./dev-db",
  },
});

import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./drizzle",
  schema: "./lib/server/schema/index.ts",
  dialect: "postgresql",
  driver: "pglite",
  dbCredentials: {
    url: "./dev-db",
  },
});

i have the drizzle-prod.config.ts:

import { defineConfig } from "drizzle-kit";
import { env } from "~/lib/env/server";

export default defineConfig({
   out: "./drizzle",
   schema: "./lib/server/schema/index.ts",
   breakpoints: true,
   dialect: "postgresql",
   dbCredentials: {
      url: env.DATABASE_URL,
   },
});

import { defineConfig } from "drizzle-kit";
import { env } from "~/lib/env/server";

export default defineConfig({
   out: "./drizzle",
   schema: "./lib/server/schema/index.ts",
   breakpoints: true,
   dialect: "postgresql",
   dbCredentials: {
      url: env.DATABASE_URL,
   },
});

db.ts

import { drizzle as drizzlePostgres } from "drizzle-orm/postgres-js";
import { drizzle as drizzlePGLite } from "drizzle-orm/pglite";
import postgres from "postgres";
import { env } from "../env/server";
import * as schema from "./schema";
import { migrate } from "drizzle-orm/pglite/migrator";

export const table = schema;

function initDb() {
   if (import.meta.env.PROD) {
      const driver = postgres(env.DATABASE_URL);
      const db = drizzlePostgres(driver, { schema });
      return db;
   } 
   return drizzlePGLite("./dev-db", { schema });
}

export const db = initDb();

import { drizzle as drizzlePostgres } from "drizzle-orm/postgres-js";
import { drizzle as drizzlePGLite } from "drizzle-orm/pglite";
import postgres from "postgres";
import { env } from "../env/server";
import * as schema from "./schema";
import { migrate } from "drizzle-orm/pglite/migrator";

export const table = schema;

function initDb() {
   if (import.meta.env.PROD) {
      const driver = postgres(env.DATABASE_URL);
      const db = drizzlePostgres(driver, { schema });
      return db;
   } 
   return drizzlePGLite("./dev-db", { schema });
}

export const db = initDb();

what im noticing is the db is being updated, say a user signs up via google oauth, but the db isnt being updated so when i run a session check its null. If i restart the dev server the db will have the user and pass the auth check

8 replies

Gaming

Programming