PERN Stack Mega Course: Postgres Express React Node 6.5Hrs!

Github Repo:
https://github.com/Sanjeev-Thiyagarajan/PERN-STACK-YELP-CLONE

FYI React hooks will be used


Today we are going to embark on a magical journey of learning the godfather of stacks... the justin timberlake of web stacks... the PERN!!!! Stack!!!!! That's right Mongo... suck it!!!


If you've been living under a rock and have no idea what the PERN stack is, well you should probably rethink your sad life. But don't worry, with this course we're going to build a really really crappy full stack yelp clone using PERN and we're going to start from the absolute basics. If you've never worked with postgres before don't worry, papa is here to walk you through all of the basics starting with installing on mac/pc, creating databases/tables, making queries, adding entries, establishing relationship between tables, sql joins.

After we show postgres who's boss, we're gonna ride express like the dirty pony that it is. We'll build a fully functional API for our crummy Yelp clone. Idk what else express can do and who really cares.

Once we're done spanking express we'll move on to the hideous fronted, which is all done in React. We'll be using React Router for routing and i will only cover hooks, cause classes are for squares.. We will dabble with the context api for state management as well as the usual local state.

this is gonna be 6.5 hrs of mind numbingly boring coding and I know you guys can't wait to get started. All code will be posted on github, because i know you morons can't follow along to a simple video.

Subscribe to my Channel:
https://www.youtube.com/channel/UC2sYgV-NV6S5_-pqLGChoNQ?sub_confirmation=1 https://twitter.com/Sanjeev_Tea https://www.instagram.com/sanjeev_tea/


If any of the react concepts are confusing to you, please check out my completely free course on react/redux

https://www.courses.sloppynetworks.com/

timestamps

00:00 Intro 04:11

PERN Stack Intro

07:58 Postgres Windows Install

16:35 Postgres Mac install

29:13 Postgres Documentation

30:29 PSQL Basics

37:04 SQL Tables

38:53 Create Table

45:55 Modify Tables

48:28 Delete Databases

50:58 Yelp Project Database

01:09:57 Node Setup

01:12:45 Express Setup

01:15:57 Environment Variables

01:19:40 First Express Route

01:29:27 Restful API Convention

01:32:33 Configure all routes

01:42:34 Express Middleware

01:54:13 Finishing Up Routes

02:03:10 Connect Express and Postgres

02:14:20 Get all Restaurants Route

2:18:25 Gone one Restaurant Route

02:28:23 Create a Restaurant Route

02:35:28 Update A Restaurant Route

02:43:07 Delete A Restaurant Route

02:46:28 React Setup

02:52:52 React Router Setup

03:02:03 HomePage Layout

03:14:24 React Context API

03:20:17 Fetching Data

03:36:12 Rendering Restaurants

03:41:48 Adding Restaurants

03:56:26 Deleting Restaurants

04:03:05 Updating Restaurants

04:26:18 Detail Page

04:38:06 Reviews Intro

04:39:46 Reviews Postgres Table

04:55:20 Star Rating Component

05:02:49 Reviews Component Layout

05:08:18 Add Review

05:29:06 Add Review Express Route

05:37:43 Add Review React Component

05:48:04 Postgres Aggregate Functions

05:57:26 SQL Joins and Wrapping up App