Setup Our PostgreSQL Database - Productivity Server 3

Published: 02 February 2024
on channel: Alexander Farrell

We need a place to store user accounts, wiki pages, goals and other data our productivity server will need. A powerful, organized and performant way to do this is by using a relational database, such as Postgres.

In this video, we install a PostgreSQL Database on Windows and Debian based Linux (Mac installation is similar to Windows), create a table for our user accounts, and cover the four basic commands in SQL: select, insert, update and delete.

In addition, we create a second user which our full-stack application will use with limited access for added security.

Create a Productivity Server Playlist:
• Full-Stack Productivity Server Tutorials

Download PostgreSQL Link:
https://www.postgresql.org/download/

Full Source Code (see the data folder):
https://github.com/AlexanderFarrell/p...

Elephant Picture Credit in Thumbnail:
https://www.pexels.com/photo/black-el...

Install on Fedora:
https://docs.fedoraproject.org/en-US/...

Install on Arch Linux:
https://wiki.archlinux.org/title/Post...

Timestamps:
00:00 - Introduction 👋
00:45 - Install Postgres on Windows 🪟
03:10 - Install Postgres on Linux (Ubuntu) 🐧
04:07 - Install VSCode Extension 🧩
04:31 - Log Into Postgres from VSCode 🔑
05:31 - Create a Second User 🙂
06:51 - Execute Queries on Database ⚡
07:32 - Create a Database 📚
08:17 - Switch Databases 🔄
08:44 - Store User Accounts in a Table 🙂🙂🙂
11:32 - Add Constraints 🛑
13:36 - Set User Permissions 🚦
14:31 - Add Data (insert statement) ➕
15:10 - Getting Data (select statement) 🔍
14:31 - Add Many Rows (insert statement again) ➕ ➕ ➕
16:47 - Changing Data (update statement) ♻
18:08 - Get Data in Order (select statement again) ⏫
19:49 - Removing Data (delete statement) 💥
20:32 - Benefits of SQL 📈
21:07 - Conclusion and Thank You 🙂

Watch video Setup Our PostgreSQL Database - Productivity Server 3 online, duration hours minute second in high quality that is uploaded to the channel Alexander Farrell 02 February 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 69 times and liked it 5 visitors.

2,450