Firee Posts - Answer Overflow

Firee

•Created by Firee on 10/13/2024 in #help

Using drizzle-kit push only works the first time (when database is empty)

I am using drizzle with supabase. I successfully pushed my schema for the first time but when updating it with new tables it hangs down in Pulling schema from database... To solve it I have to delete all the tables or intentionally make an error somewhere in drizzle config. Is this my issue or drizzle issue? I have been seeing similar cases but with no solution yet. versions "drizzle-orm": "^0.34.1" "drizzle-kit": "^0.25.0"

drizzle.config.ts
import { type Config } from "drizzle-kit";

import { env } from "~/env";

export default {
  schema: "./src/server/db/schema.ts",
  dialect: "postgresql",
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  tablesFilter: ["test_*"],
} satisfies Config;

drizzle.config.ts
import { type Config } from "drizzle-kit";

import { env } from "~/env";

export default {
  schema: "./src/server/db/schema.ts",
  dialect: "postgresql",
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  tablesFilter: ["test_*"],
} satisfies Config;

4 replies

Gaming

Programming