Drizzle Team•4d ago

Help with the connection between Drizzle and Supabase

Good afternoon!! Could anyone help me with the connection between Drizzle and Supabase in a Remix application? I'm having trouble getting it to work.
Thanks in advance!

6 Replies

DoggeSlapper•4d ago

what error u getting?

Samiihh•4d ago

Samiihh•4d ago

DoggeSlapper•4d ago

try the non pool connection there wait's I though it was on drizzle kit my bad It might be related to ur password do u have any $ in it?

Samiihh•4d ago

"No, just letters and numbers."

DoggeSlapper•4d ago

strange, just to doublecehck try

const {
  PGHOST: host,
  PGUSER: user,
  PGDATABASE: database,
  PGPASSWORD: password,
} = process.env;

export const connectionString = `postgresql://${user}:${encodeURIComponent(password)}@${host}`;

const {
  PGHOST: host,
  PGUSER: user,
  PGDATABASE: database,
  PGPASSWORD: password,
} = process.env;

export const connectionString = `postgresql://${user}:${encodeURIComponent(password)}@${host}`;

Gaming

Programming

Help with the connection between Drizzle and Supabase