Connection Pooling | Cave of Programming

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Introduction to React and NodeJS

Introduction

Introduction (5:51)

Preparation

Terminals (4:02)
Installing Software (8:52)
Overall Design (3:04)
Using GitHub (4:12)
Where to Find Source Code (3:19)

Creating a React App

Creating a React App (6:09)
Editing the Default App (7:24)
How the App Works (10:50)
Creating a Component (12:49)

Creating a Server with Express

Creating a Server (7:54)
Installing Express (7:23)
Creating a Route (7:58)
Creating a Database (10:49)
Creating a User (7:25)
A Properties File (5:22)
Improving Server Startup (8:45)
Connecting to MySQL (9:47)
MySQL Set Syntax (4:22)
Inserting a Row (4:51)
Connection Pooling (6:31)
Implementing Pooling (5:53)
About Releasing Connections (5:16)

Implementing a REST Service

Handling Posts (9:06)
Implementing Create (3:50)
About REST (4:26)
Implementing PUT and DELETE (6:03)
A Book Repository (7:27)
Handling Errors (7:55)
Updating Data (7:30)
Getting Data (4:35)
Deleting Data (3:43)

Connecting Client and Server

Running Commands Concurrently (8:11)
Environment Variables (4:26)
CORS (4:32)
Fetching Data (8:11)
State (5:58)
Formatting with Map (9:25)
Adding a Header (3:13)
Styling the Header (10:20)
Adding Material UI Icons (4:17)
Styling the Table (6:35)

React Router

React Router (8:43)

Working with Forms

Creating a Form (9:00)
Controlled Forms (7:51)
Submitting Forms (3:39)
Enabling Book Creation (6:30)
Redirects (2:33)
Validation Rules (8:44)
Flash Messages (5:18)
Validating the Form (1:56)

Creating Function Components

Using Props (4:43)
Hooks (4:32)
The UseEffect Hook (5:02)
Re-rendering with Keys (4:33)

Updating and Deleting

Passing Params in Router (4:29)
Updating Books (4:48)
Handling Delete (8:59)
Loading the Book Data (3:46)
Harmonising Dates Bugfix (1:50)

Handling Errors

A BookTable Component (5:39)
Adding a Loading Message (5:57)
Loading Failed Message (5:48)
Handling Delete Errors (7:23)
Handling Saving and Loading Errors (5:22)

Conclusion

Conclusion (3:36)

Teach online with

Connection Pooling

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock