26 replies

Hey, I'm having some trouble with

Hey, I'm having some trouble with database connections through Hyperdrive and hoping someone can point me in the right direction.

My setup is a Cloudflare Worker using Hono, PostgreSQL connected via Hyperdrive, and Drizzle ORM with the pg driver.

The issue is that without

maxUses: 1

maxUses: 1

in my pg.Pool config, requests hang forever and eventually get cancelled with "Worker's code had hung and would never generate a response." But with

maxUses: 1

maxUses: 1

every single query takes 300ms+ because (I assume) it's creating a fresh connection each time.

Making requests through Postman to the prod API is giving ~20ms times which is about what I expect, but the deployed website calling the API is sometimes in the 300-500ms range.

I've tried a few things:
- Using pg Pool without maxUses: 1 causes requests to hang indefinitely.
- Switching to postgres-js with max: 1 worked great locally, but in production I got "Cannot perform I/O on behalf of a different request" errors.
- Creating per-request connections using AsyncLocalStorage was still slow and had occasional hangs.

My current working code looks like this:

const pool = new Pool({
  connectionString: env.DB.connectionString,
  maxUses: 1
})

const pool = new Pool({
  connectionString: env.DB.connectionString,
  maxUses: 1
})

maxUses: 1

maxUses: 1

the expected pattern when using Hyperdrive? I thought Hyperdrive handled connection pooling on its end, but the client-side behavior seems to require fresh connections for every query. Am I missing something or is this just how it works?

Hey, I'm having some trouble with

maxUses: 1

maxUses: 1

in my pg.Pool config, requests hang forever and eventually get cancelled with "Worker's code had hung and would never generate a response." But with

maxUses: 1

maxUses: 1

const pool = new Pool({
  connectionString: env.DB.connectionString,
  maxUses: 1
})

const pool = new Pool({
  connectionString: env.DB.connectionString,
  maxUses: 1
})

maxUses: 1

maxUses: 1

Hey, I'm having some trouble with

Similar Threads

Hey, I'm having some trouble with

Similar Threads

Similar Threads

Similar Threads