TARS Posts - Answer Overflow

TARS

Explore posts from servers

PPrisma TTCTheo's Typesafe Cult DTDrizzle Team KKinde

•Created by TARS on 10/9/2024 in #help

Cant drizzle-kit pull with next.js from supabase postgres

Hello, trying to learn drizzle by connecting it to an existing supabase project (postgres), and need to pull the DB schemas into drizzle. My drizzle.config.ts:

import { config } from "dotenv";
import { defineConfig } from "drizzle-kit";
config({ path: ".env.local" });
export default defineConfig({
  schema: "./src/db/schema.ts",
  out: "./db/migrations",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.NEXT_PRIVATE_DB_CONNECTION_STRING!,
  },
  
});

import { config } from "dotenv";
import { defineConfig } from "drizzle-kit";
config({ path: ".env.local" });
export default defineConfig({
  schema: "./src/db/schema.ts",
  out: "./db/migrations",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.NEXT_PRIVATE_DB_CONNECTION_STRING!,
  },
  
});

$ npx drizzle-kit pull No config path provided, using default 'drizzle.config.ts' Reading config file 'C:\webdev\sprent-backoffice\drizzle.config.ts' Pulling from ['public'] list of schemas Using 'pg' driver for database querying [⣟] 0 tables fetching [⣟] 0 columns fetching [⣟] 0 enums fetching [⣟] 0 indexes fetching [⣟] 0 foreign keys fetching Error: SASL: SCRAM-SERVER-FINAL-MESSAGE: server signature is missing Not sure where to start solving this issue.. help would be most appreciated!

8 replies

Gaming

Programming