Connection Pooling in PostgresSQL with NodeJS (Performance Numbers)

Опубликовано: 05 Октябрь 2024
на канале: Hussein Nasser

77,524

1.8k

Connection pooling is a pattern of creating a pool of available connections (usually TCP) and allow multiple clients to share the same pool of connections. This pattern is usually used when connection establishment and tearing down is costly, and the server has a limited number of connections.

In this video we will learn how to use connection pooling in NodeJs when working with a Postgres Database, we will learn how to spin up a pool of database connections and use stateless pool queries and transactional queries begin/end, and finally, we will

0:00 Intro
3:00 stateless close/open
4:30 Pooling approach
8:20 Performance tests

Source Code

https://github.com/hnasr/javascript_p...

Stay Awesome!
Hussein