Tyler Comments - Answer Overflow

Tyler

•Created by Misc on 3/28/2025 in #help

Consistently hitting max clients/connections on postgres

This is my implementation, which is similar but I just use the defaults of things.

const connectionString = String(process.env.DATABASE_URL);

declare module global {
  let postgresSqlClient: ReturnType<typeof postgres> | undefined;
}

let postgresSqlClient;

if (process.env.NODE_ENV !== 'production') {
  if (!global.postgresSqlClient) {
    global.postgresSqlClient = postgres(connectionString);
  }
  postgresSqlClient = global.postgresSqlClient;
} else {
  postgresSqlClient = postgres(connectionString);
}

export const client = postgresSqlClient;
export const db = drizzle(postgresSqlClient);

const connectionString = String(process.env.DATABASE_URL);

declare module global {
  let postgresSqlClient: ReturnType<typeof postgres> | undefined;
}

let postgresSqlClient;

if (process.env.NODE_ENV !== 'production') {
  if (!global.postgresSqlClient) {
    global.postgresSqlClient = postgres(connectionString);
  }
  postgresSqlClient = global.postgresSqlClient;
} else {
  postgresSqlClient = postgres(connectionString);
}

export const client = postgresSqlClient;
export const db = drizzle(postgresSqlClient);

6 replies

DTDrizzle Team

•Created by Misc on 3/28/2025 in #help

Consistently hitting max clients/connections on postgres

Is there a specific reason why you set poolConfig?

6 replies

DTDrizzle Team

•Created by Tyler on 3/28/2025 in #help

Non-escape character breaks select function

I think this documentation here may be effected: https://orm.drizzle.team/docs/rls in that there are calls to things like:

await tx.execute(sql`
          -- auth.jwt()
          select set_config('request.jwt.claims', '${sql.raw(
            JSON.stringify(token)
          )}', TRUE);

await tx.execute(sql`
          -- auth.jwt()
          select set_config('request.jwt.claims', '${sql.raw(
            JSON.stringify(token)
          )}', TRUE);

But, if the token contains data with an apostrophe, it breaks that call.

4 replies

DTDrizzle Team

•Created by Tyler on 3/28/2025 in #help

Non-escape character breaks select function

I've identified it's not the selects, I think its the data inside the session object...

4 replies

DTDrizzle Team

•Created by Tyler on 3/28/2025 in #help

Non-escape character breaks select function

After talking to Supabase peeps, pretty positive it's a drizzle issue (or at least not Supabase).

4 replies

DTDrizzle Team

•Created by Misc on 3/28/2025 in #help

Consistently hitting max clients/connections on postgres

I had this a lot on dev mode, but not production. What's your config look like?

6 replies

TTCTheo's Typesafe Cult

•Created by Gary, el Pingüino Artefacto on 2/24/2025 in #questions

Migrating from a Create Next App to TurboRepo

There's a pretty good starter you could look at for things like that in makerkit's github. I referenced that a lot when migrating. It splits out the Eslint and other tooling into its own packages/, and I liked that approach

4 replies

Gaming

Programming