News for hackers. Stuff that matters.

A comment on MySQL Challenge: 100k Connections. Parent comment

Re:MySQL Challenge: 100k Connections by jashmatthews on Monday February 25, 2019 @08:20PM (#19251222)
Prepared statements actually work fine with PGBouncer. Anonymous prepared statements via PqExecParams work completely without issue. No need to go back to escaping and putting params in the query string!

Named prepared statements via PREPARE also work, but the client needs to use deterministic names and rescue if the query isn’t prepared: https://github.com/diesel-rs/diesel/issues/1028#issuecomment...

[ Parent | on HN ]
Re:MySQL Challenge: 100k Connections by EB66 on Monday February 25, 2019 @08:56PM (#19251381)
I was just about to comment the same thing. We use PgBouncer for some of our production databases and we make heavy use of prepared statements, stored procedures, etc.
[ Parent | on HN ]