Does Drizzle autogenerate prepared statements under the hood?

Supabase is telling me that PGBouncer and their own Supavisor both don't support prepared statements. We don't use prepared statement but I see queries that look like autogenerated prepared statement ids If so, can we disable it?
7 Replies
msu
msuOP14mo ago
Seeing messages like prepared statement "l1wmyog929416" does not exist prepared statement"ye655i5hxc396" does not exist
kratious
kratious14mo ago
PostgresJS does autogenerate, if you're using that https://github.com/porsager/postgres#prepared-statements
GitHub
GitHub - porsager/postgres: Postgres.js - The Fastest full featured...
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno - GitHub - porsager/postgres: Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno
msu
msuOP14mo ago
@kratious do you know if pg does as well? We're on postgres.js but can swap over to prevent the named statements
Screw
Screw14mo ago
are you using transactions ?
kratious
kratious14mo ago
pg doesn't. You can turn off the autogenerating with prepare: false for postgres.js too
msu
msuOP14mo ago
not much. maybe one or two got it -- thanks
Screw
Screw14mo ago
i had to stop using transactions and i stopped getting that issue
Want results from more Discord servers?
Add your server