Skip to content

Latest commit

 

History

History
32 lines (21 loc) · 1.26 KB

README.md

File metadata and controls

32 lines (21 loc) · 1.26 KB
Raw

Author: @shiryz

Maintainer: TBC

Getting Started

Clone this repo: git clone https://github.com/foundersandcoders/pg-walkthrough.git

Learning Outcomes

Building a database

  • Creating a build script in an .sql file
  • Using the DROP and IF EXISTS commands, for use on a test database
  • What cascade is for and when to use it
  • Execute a transaction using BEGIN & COMMIT

Connecting to a database

  • Connecting to a PostgreSQL server from a node server, including the setup of environment variables (heroku)

Running queries in Node

  • Understanding what a connection pool is and how to initialise and configure one using pg
  • Using pool.query with callbacks, to execute single queries to the database
  • Using parameterised queries (to prevent SQL injection)
  • Serving the query results to the front end

Postgres Connection Walkthrough

This exercise is designed to get you familiar with connecting to a database, querying it and viewing that information. We'll be using the npm module pg to connect our node server to a locally-hosted Postgres database.

Inspired by Matthew Glover and his awesome pg-app