PgBouncer is useful, important, and fraught with peril
To start, I want to say that Iām appreciative that PgBouncer exists and the work its open source maintainers put into it. I also love working with PostgreSQL, and Iām thankful for the incredible amount of work and improvements that go into it as well. I also think community and industry enthusiasm around Postgres is at an all time high. There are more managed hosting options than ever (Crunchy Data, Render, Fly.
Crunchy Data Prevention Cheatsheet Prepared Statements Parameterized Queries Render Postgres Level Advisory Locks
Source: jpcamara.com