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•13mo 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•13mo 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•13mo 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•13mo 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•13mo 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•9mo 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