Setup Our PostgreSQL Database - Productivity Server 3
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 without registration, duration hours minute second in high quality. This video was added by user Alexander Farrell 02 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 69 once and liked it 5 people.