Connect Node to Postgres

Learn how to connect a Node application to a postgres database using the node-postgres or pg npm library, what connection pooling is, the pg npm library, and managing environment variables with dotenv.

👩‍💻 Download Code 👨‍💻

🛜 Download My Chrome Extension 🛜

💻 Compare Laptop Specs 💻

🔴 Rare Pokemon Cards ⚪️

👻 90s Nostalgia 👻

⌛Timestamps⌛
0:00 – Introduction
0:09 – Creating a Node Project
0:43 – Downloading node-postgres or pg
1:10 – pg Client vs Pool
2:04 – Environment Variables and dotenv
4:33 – Connecting to Postgres with pg Pool
5:09 – Querying Postgres with pg Pool
7:05 – Debugging
7:41 – Pool vs Client
8:22 – Outro

[KletschkeCoding]

Thanks so much! This video is really helpful! :)

[amanuelelhanan]

Amazing brother thank you so much, I really really want you to show us how to run insert query inside loops in situation iterating on array data and insert them to table, please

[louisveronneau]

thanks ! I had to add ssl: {
rejectUnauthorized: false,
}
as an option but nice !

[albinmiftari]

How can I now fetch the data and use it?

[harshitvishwakarma]

I was more focused on your typing speed than actual topic 😅