💻 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
En esta página del sitio puede ver el video en línea Step by Step Javascript and Postgres Tutorial using node-postgres de Duración hora minuto segunda en buena calidad , que subió el usuario Hussein Nasser 26 enero 2019, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 118,969 veces y le gustó 2 mil a los espectadores. Disfruta viendo!