#9 Python Flask Tutorial for Beginners - Flask SQLAlchemy Postgres Tutorial - Postgres Flask

Join Code Jana --- Flask Discord Server : https://discord.gg/78pgAs8ez6.
Share your issues & problems & chat with everyone regarding Python Flask web-framework. Hi Coders, db.session.add('Use Postgres Database for Scalable Web App'). In this video, we'll learn about Flask SQLAlchemy Postgres.
You'll learn several new things in this video. So make sure to watch it till the end.
✔? Learn Flask in 1 Video: Flask Complete Tutorial: https://youtu.be/Z7MS0TI3Zhk

Join our Python Flask Student Community on Whatsapp - https://chat.whatsapp.com/ICZeAvDH95T0OILwQtR34S

Videos in Flask Tutorial Series:
#0 - Flask App Intro -
https://youtu.be/sndILKXxMsA

#1 - Flask Installation & Best VSCode Extensions for Python -
https://youtu.be/fgxXjKhSbE4

#2 - Layout & Website Structure in Flask App -
https://youtu.be/Bamuqt31BpI

#3 - Adding Bootstrap, Custom CSS, JS in Flask App -
https://youtu.be/LcZDBFder1s

#4 - Creating Navbar Using Bootstrap v5 in Flask App -
https://youtu.be/iBBciQeFy18

#5 - Bootstrap 5 Cards in Flask App -
https://youtu.be/tLSVP1dy4-s

#6 - Creating Slider with Bootstrap 5 in Flask App -
https://youtu.be/kcWYe64SFB8

#7 - Register & Login Page with Flask WTF -
https://youtu.be/h4FFSlw_U6g

#8 - Flask SQLAlchemy Tutorial - Creating Database in 3 Steps with SQLite - https://youtu.be/Glarn2Y4dj8

#9 - Flask SQLAlchemy Postgres Tutorial -
https://youtu.be/ioV_Zj_DJKM

#10 - Flask Bcrypt Authentication -
https://youtu.be/Vr6wdxQJw0A

#11 - Flask Login Tutorial - Manage User Session in 3 Steps -
https://youtu.be/gHfUt-N2_Jw

#12 - Flask Forgot Password Setup - Create Itsdangerous Token in 3 Steps - https://youtu.be/zYWpEJAHvaI

#13 - Flask Upload Image - Easily Upload Image to Database -
https://youtu.be/lg1k2klqkdQ

#14 - Flask SQLAlchemy Relationship - One to Many Relation -
https://youtu.be/PYUHyf3WLVA

#15 Deploy Flask App to Heroku - Flask Tutorial Series - Gunicorn Server -
https://youtu.be/qk68n-eiqHo

#16 Deploy Flask App to AWS -
https://youtu.be/I_ooKfpFHJ4
Please support me via Patreon: https://www.patreon.com/codejana

For beginners SQLite is a good choice but if you want to deploy your app online & want to scale your application later at some point then creating a Postgres database is preferable.
That's after covering SQLAlchemy SQLite in my earlier video, I am covering SQLAlchemy Postgres in this one.
So, these are the commands that you are going to be needing to work with Postgres:
1. Create a new user
create user 'username' with password 'password';
2. Assign roles and attributes to user
alter user 'username' with superuser;
alter user 'username' with createdb;
3. Switch user
\c 'database name' 'username'
4. Create database with new user
create database 'database name';
5. \du - display all users
6. \l - list all tables in a database
7. \q - quit psql shell.

Please support my efforts by contributing through Patreon:
https://www.patreon.com/codejana

Please Like, Share and Subscribe to Code Jana.
Thanks for Watching & I'll see you in the next one.