Tutorials

High quality tutorials for PostgreSQL, ExpressJS, ReactJS and NodeJS fullstack developers.

Visual Studio Code Tutorial: Remote Development through SSH
Owen Phillips

Visual Studio Code Tutorial: Remote Development through SSH

In this tutorial, you'll learn how to set up and use the SSH remote development extension for Visual Studio Code. With this extension, you can easily open and manipulate folders on a remote computer using the power of vs code on your local machine.2020-12-27
Read article
Build an Admin Template w/ Semantic UI React - Part 2: Login/Signup
Owen Phillips

Build an Admin Template w/ Semantic UI React - Part 2: Login/Signup

In this tutorial, you will create a login and a signup page using Semantic UI React components and React Router 5. This is part 2 of a series of tutorials where we walk you through building an admin template/dashboard using Semantic UI React, React Router 5 and React Redux.2019-09-17
Read article
Build an Admin Template w/ Semantic UI React - Part 1: Intro/Setup
Owen Phillips

Build an Admin Template w/ Semantic UI React - Part 1: Intro/Setup

In this tutorial, we will introduce our admin template/dashboard project and setup Semantic UI React with Create React App. This is part 1 of a series of tutorials where we walk you through building an admin template/dashboard using Semantic UI React, React Router 5 and React Redux.2019-08-11
Read article
Create a REST API [Part 7]: Forgot / Reset Password Routes
Owen Phillips

Create a REST API [Part 7]: Forgot / Reset Password Routes

In this tutorial, you will create API routes that will allow users to reset a lost password in your PostgreSQL database using KnexJS to make the connection. This is part 7 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2019-07-23
Read article
Create a REST API [Part 6]: User Login with JWT Authentication
Owen Phillips

Create a REST API [Part 6]: User Login with JWT Authentication

In this tutorial, you will create a user login route for your API that takes an email and password, verifies they match what's in your database and returns a JSON Web Token if they do. This is part 6 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2019-07-21
Read article
How to Install PostgreSQL on Windows
Owen Phillips

How to Install PostgreSQL on Windows

Installing PostgreSQL on Windows for the first time can be a little intimidating and you might be left wondering if you even did it right. Follow this guide and rest assured you will have a properly installed PostgreSQL database on Windows.2019-07-20
Read article
PostgreSQL Tutorial - Basics (Windows)
Owen Phillips

PostgreSQL Tutorial - Basics (Windows)

In this tutorial, we will go over some PostgreSQL basics that new developers must be familiar with. You will learn to create users, databases, tables, and columns and add data (rows) to tables using pgAdmin and the psql shell.2019-07-20
Read article
Create a REST API [Part 5]: Verify Users with Tokens
Owen Phillips

Create a REST API [Part 5]: Verify Users with Tokens

In this tutorial, you will create a new API route that is passed a verification token used to confirm a user registration through your API by updating an entry in your PostgreSQL database. This is part 5 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2018-12-08
Read article
Create a REST API [Part 4]: Send Emails with Amazon SES
Owen Phillips

Create a REST API [Part 4]: Send Emails with Amazon SES

In this tutorial, you will use Amazon's Simple Email Service to send an email to your users with a verification token when they register using your API. This is part 4 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2018-12-07
Read article
Create a REST API [Part 3]: User Registration and Validation
Owen Phillips

Create a REST API [Part 3]: User Registration and Validation

In this tutorial, you will create a user registration route for your API, validate input passed to the route and add a user to your PostgreSQL database. This is part 3 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2018-12-06
Read article
Create a REST API [Part 2]: PostgreSQL with KnexJS Setup
Owen Phillips

Create a REST API [Part 2]: PostgreSQL with KnexJS Setup

In this tutorial, we will continue with our simple-api project by creating a Postgres database and get ready to connect to it with KnexJS. This is part 2 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2018-12-05
Read article
Create a REST API [Part 1]: Project Setup with Express
Owen Phillips

Create a REST API [Part 1]: Project Setup with Express

In this tutorial, we will create a new NodeJS project with ExpressJS, body-parser, and nodemon and get our server.js file ready to build a REST API. This is part 1 of a series of tutorials on building a REST API in Node with ExpressJS, KnexJS, and PostgreSQL.2018-12-04
Read article
React Tutorial - Getting started with Material-UI
Owen Phillips

React Tutorial - Getting started with Material-UI

In this tutorial, we will get started with Material-UI using the Grid, Paper, Typography, Avatar, and withStyles components and even make use of material icons. Let's get started!2018-11-27
Read article
Create a React App in 5 Steps
Owen Phillips

Create a React App in 5 Steps

There are many ways to create a React app but the easiest by far is through the create-react-app NPM package from Facebook. With a few simple commands, you will have a barebones application that you can use as the foundation for your projects.2018-11-26
Read article
Learn React - What is JSX
Owen Phillips

Learn React - What is JSX

You might have heard of JSX by now if you have spent any amount of time looking into React. You may have wondered to yourself 'what is JSX' but didn’t' know where to start. JSX is basically HTML in JavaScript and in this quick tutorial you will understand what that means.2018-11-26
Read article
Learn React - What is React?
Owen Phillips

Learn React - What is React?

React is a JavaScript framework developed and maintained by Facebook for the purpose of creating interactive user interfaces. It follows a 'Learn once, write anywhere' philosophy and allows you to develop native applications for multiple platforms.2018-11-25
Read article