Part of the Free Full-stack course: https://www.youtube.com/playlist?list=PL6yRaaP0WPkXo7Kl6LQcO69bsYTS7BDxo

Welcome to the Free Full-stack Course

In this course, we will be using Python as the programming language for our backend to deliver REST APIs. The REST APIs will be developed on top of Django which is a backend/website framework that sits on top of Python. And we will also use DRF (Django REST Framework) to actually deliver our APIs on top of Django.

PostgreSQL is the world's most advanced open-source relational database. Later when we get to the backend development part of this course with Django and Django REST Framework (DRF), we will use PostgreSQL as our database system so it's important that we set it up correctly in this chapter. In this chapter we will install PostgreSQL on macOS.

Timestamps:
00:00 - Installing PostgreSQL on macOS
00:38 - What is PostgreSQL?
01:15 - You will need Homebrew
01:56 - Installing PostgreSQL with Homebrew
03:09 - Starting or stopping the service
04:25 - PostgreSQL uses Ident Authentication
06:13 - User matches the database
06:23 - Create a new admin user in System Preferences
09:04 - Create a role for your new user
11:54 - Create a DB for your new user
13:33 - Log into "fullstackcourse" user
15:53 - Log into PostgreSQL
16:48 - Get your connection information
17:44 - You've successfully installed PostgreSQL on macOS

If you want to support my work, please consider joining my YouTube channel by pressing the Join button!

Twitter: https://twitter.com/vandadnp
LinkedIn: https://linkedin.com/in/vandadnp

Let's get started!