DT
Drizzle TeamScrew

Transactions, PgBouncer/Supavisor, prepared statements

okay... i have spent way to long trying to figure out why when using transactions and a pooler on transaction mode it causes the connection to reset mid transaction statement causing a prepared statement 'name' does not exist which was very hard to debug. still don't fully understand why transaction won't work i've tried everything i could find setting params binary_parameters=yes (not even sure what this does, resetting database server (supabase). using a direct connection worked but wasn't something i could do forever. so my fix was.... just remove transactions from my endpoints (which sucks but it is what it is) if anyone else has this issue would love some help on how you worked around this or fixed???
Xafets
Xafets•220d ago
Bump, having this error now myself
Want results from more Discord servers?
Add your server
More Posts
how enable wal for sqlite with drizzle ?how enable wal for sqlite with drizzle ?Simple ForeignKey With statement not workingHi - I am attempting to use a with statement on a query and am getting this error: Cannot read propMySQL UUID as PKI am unable to get a PK setup which has a default UUID value. I have ```ts logID: varchar('logID'totalCount from relational queryis it somehow possible to get the total count of a relational query? Core queries aren't possible h