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
#postgres #express #react #node
