Setup Our PostgreSQL Database - Productivity Server 3

Опубликовано: 02 Февраль 2024
на канале: 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 🙂

Смотрите видео Setup Our PostgreSQL Database - Productivity Server 3 онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Alexander Farrell 02 Февраль 2024. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 69 раз и оно понравилось 5 посетителям.

2,450