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 🙂
Auf dieser Seite können Sie das Online-Video Setup Our PostgreSQL Database - Productivity Server 3 mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Alexander Farrell 02 Februar 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 86 Mal angesehen und es wurde von 5 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
