How to Use Databases With SQLAlchemy - Flask Fridays #8

Video Description

In this video I'll show you how to use databases with Flask using SQLAlchemy! Using databases with flask is a little harder than with other web frameworks, but it doesn't have to be too bad if you use SQLAlchemy. I'll show you how in this video by setting up a SQLite database and creating a table, and then adding a form to the site that allows us to add data to the database. After we learn how to do this with SQLite, we'll learn about MySQL and Postgres. Timecodes 0:00​​ - Introduction 1:13 - Pip Install Flask-SQLAlchemy 1:56 - Import SQLalchemy To Our Flask App 2:55 - Set SQLAlchemy Database URI For SQLITE 4:20 - Initialize The Database 4:50 - Create Our Database Model 9:39 - Import Model From The Terminal 10:38 - Create UserForm 11:25 - Create Route And Add_User Function 12:20 - Create Add_User.html Page 13:24 - Add Link To Add_User.html on Navbar 14:22 - Set Form to UserForm in Add_User Function 15:00 - Validate Form On Submit 16:54 - Save Data To Database On Submit 18:50 - Query Database And Output Users To Webpage 21:37 - Style Form With Bootstrap 22:37 - Add Table For User Output 24:46 - Conclusion