Installing PostgreSQL on macOS - Free Full-stack Course 🦄

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!