Express with pg

pg

Objectives

• Integrate the pg module into your app
• Write SQL Queries against your Postgres database
• Use data from your database to serve views
• Collect data from views and put it into your database

What's  pg ?

pg

Let's build an Express app and access our database

1. Build our database

CREATE DATABASE pgteas;

\c pgteas

CREATE TABLE teas (
    id serial PRIMARY KEY,
    name varchar(150),
    flavor varchar(150),
    in_stock bool
);

INSERT INTO teas (name, flavor, in_stock) VALUES ('green tea', 'greeny', TRUE);
INSERT INTO teas (name, flavor, in_stock) VALUES ('blue tea', 'blueish', false);
INSERT INTO teas (name, flavor, in_stock) VALUES ('red tea', 'reddish', TRUE);
INSERT INTO teas (name, flavor, in_stock) VALUES ('yellow tea', 'lemony', TRUE);

1. Build our database

2. Create Express app

1. Build our database

2. Create Express app

3. Connect app to database...?

Jump into your  node   environment

node

1. Build our database

2. Create Express app

3. Connect app to database!

Whiteboards

Rendering data

Poetry

Gathering data

CRUD with puppies

3-2-1