fluxe Posts - Answer Overflow

fluxe

•Created by fluxe on 12/27/2023 in #help

Prepared queries don't appear to be generated

I'm using Drizzle with Postgres.js, which should auto generate prepared queries. I have this query here

const prepared = db
  .select({ response: customResponses.response })
  .from(customResponses)
  .where(eq(customResponses.trigger, sql.placeholder("trigger")))
  .prepare("find_custom_response");

const prepared = db
  .select({ response: customResponses.response })
  .from(customResponses)
  .where(eq(customResponses.trigger, sql.placeholder("trigger")))
  .prepare("find_custom_response");

and have tested this query both with and without prepare. I've then (on the same application) run

await db
    .select()
    .from(sql`pg_prepared_statements`)
    .execute();

await db
    .select()
    .from(sql`pg_prepared_statements`)
    .execute();

to confirm that the prepared statement was created, but it always returns 0 rows, even after running the first query a bunch of times. I've also confirmed that the issue remains even after setting prepare: true in the Postgres.js config. Is there an issue here, or is my understanding of checking for prepared statements wrong?

3 replies

Gaming

Programming