drizzle studio blank screen

the behaviour is same on both firefox and brave(shields disabled), so doesn't seem like a browser problem.

7 Replies

what does your configuration look like for your db connection? 429 is a rate limit issue in general 🤔

adrtivvOP•12mo ago

// dotenv required for `drizzle-studio push:pg`
import dotenv from "dotenv";
dotenv.config();
import type { Config } from "drizzle-kit";

export default {
  driver: "pg",
  dbCredentials: {
    connectionString: process.env.DATABASE_URL!,
  },
  out: "./migrations",
  schema: "./src/db/schema.ts",
  // this field needed when using `drizzle-studio push:pg` dunno why
  schemaFilter: "schemaOne",
} satisfies Config;

// dotenv required for `drizzle-studio push:pg`
import dotenv from "dotenv";
dotenv.config();
import type { Config } from "drizzle-kit";

export default {
  driver: "pg",
  dbCredentials: {
    connectionString: process.env.DATABASE_URL!,
  },
  out: "./migrations",
  schema: "./src/db/schema.ts",
  // this field needed when using `drizzle-studio push:pg` dunno why
  schemaFilter: "schemaOne",
} satisfies Config;

I'm using a local database btw, booted up in a podman container and yeah it does work with the drizzle client so I don't think the config has any issue.

postgresql://username:password@localhost:5432/postgres_db?search_path=schemaOne

postgresql://username:password@localhost:5432/postgres_db?search_path=schemaOne

Darth_Fuzzy•12mo ago

i have no idea what schemaOne is, but my connection string has the query params of sslmode=require&pgbouncer=true on it. also I have a tablesFilter: ["myprojectname_*"], defined in the config

adrtivvOP•12mo ago

https://www.postgresql.org/docs/current/ddl-schemas.html

PostgreSQL Documentation

5.9. Schemas

5.9. Schemas # 5.9.1. Creating a Schema 5.9.2. The Public Schema 5.9.3. The Schema Search Path 5.9.4. Schemas and Privileges 5.9.5. …

adrtivvOP•12mo ago

found an issue regarding this https://github.com/drizzle-team/drizzle-kit-mirror/issues/250

GitHub

drizzle kit studio does not work when public schema has no tables ·...

All of my table are in non public schema and this seems to trip drizzle kit up

LiquiFruit•12mo ago

Can confirm this is happening to me using Drizzle + Turso/SQLite. Just found out that this happened in Chrome but not Edge. Could be worth testing.

Ibnu Rasikh - creatypestudio.co•8mo ago

went the same problem, the solution i get is just activate or deactivate Cloudflare WRAP or 1.1.1.1, maybe someone else have the same condition with me (dunno why it's affect)

Gaming

Programming

drizzle studio blank screen