Database Connection Pooling With pgbouncer

Written by MichaelB | Published 2020/06/07
Tech Story Tags: database | postgres | database-architecture | software-architecture | heroku | backend | postgresql | pgbouncer | web-monetization

TLDR Connection Pools are a cache of open database connections that can be reused by clients. Using a pool mitigates strain on the database by reducing requests for new connections. Pools increase performance of individual database calls, since no time is spent requesting and opening the connection. You can create your pool at the language level, on your client, as middleware, or as some hybrid of those choices. The ideal location of your pool will depend on your unique situation. For a modern app with many many app, use middleware to let you dive into common use cases.via the TL;DR App

no story

Written by MichaelB | I run Dev Spotlight - we write tech content for tech companies. Email at [email protected].
Published by HackerNoon on 2020/06/07