node-postgres Connection Pool

Learn how to use the node-postgres or pg library connection pool. We will learn how to connect a node application to a postgres database, learn what a connection pool is, when to use a connection pool, the benefits of a connection pool, and how to configure a connection pool.

👩‍💻 Download Code 👨‍💻

🛜 Download My Chrome Extension 🛜

💻 Compare Laptop Specs 💻

🔴 Rare Pokemon Cards ⚪️

👻 90s Nostalgia 👻

⌛Timestamps⌛
0:00 – Introduction
0:07 – What is a Connection Pool?
0:19 – Why use a Connection Pool?
0:31 – When to use a Connection Pool
1:00 – Create a Connection Pool with pg
2:26 – Configure pg Connection Pool
4:24 – Checking out a Connection from the Pool
5:26 – Checking Pool Connections
5:57 – Querying Postgres with the Pool
6:59 – Releasing a Connection Back to the Pool
8:08 – Querying Postgres with the Pool Automatically
8:59 – Closing a Connection Pool
9:27 – Connection Pool and EventEmitter
10:21 – Outro

[SuperMBARutgers]

Fantastic. Could get into seeing errors from the database eg constraint validation on insert etc

[albinmiftari]

Now that we can connect to the database how can we actually display the data on a react website?