Step by Step Javascript and Postgres Tutorial using node-postgres

💻 More Software engineering videos    • Software Engineering by Example  

In this video, we will learn how to connect to a Postgres database from Javascript. We will learn how to perform queries on a table. We will go through an Insert example and learn how to do transactions. You can through jump codes table of content to jump to areas of the code of interest to you.

Requirements
1. NodeJS 10 or later,    • Turn your laptop into a Web Server to serv...  
2. PostgresSQL database    • Spinning multiple Postgres instances and P...  
3. Visual Studio Code https://code.visualstudio.com/
4. Using #node-postgres npm library https://node-postgres.com/

Reference Videos
Atomic Transactions

Jump Codes Table of Content
0:00 Intro
02:50 Creating new NodeJS Project
06:40 The node-postgres npm library
10:40 Connecting to the postgres database (promises)
13:30 Executing queries (promises)
18:10 Executing queries with parameters (promises)
22:00 Executing Insert statement (DML) (Promises)
26:22 Connecting to postgres (Async/await)
37:00 The Results object of the query
39:40 Executing Transactions in Javascript (Begin, Commit/Rollback)

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

Enjoy 😉

Stay Awesome!
Hussein