Flask SQLite Web Application Step by Step Tutorial - HTML, Jinja, CSS, JavaScript, Python

Published: 01 January 1970
on channel: Python Simplified

100,030

2.3k

In this tutorial we will see how to create a web application using Flask and SQLite. Flask is a web framework using Python for the backend, HTML and Jinja for templating, CSS for styling and JavaScript for client side interactions.
So today, will not only connect databases to a Flask server - but we will also learn how to use all the perks of this framework.

🛑 Please note: Wayscript is no longer with us! RIP!
🛑 Please refer to the Github repo instead!

⭐ Clone Starter Files and Complete Groceries App from Github:
https://github.com/MariyaSha/grocerie...

⏰ TIME STAMPS ⏰
---------------------------------------------------------------
00:00 - Intro
00:48 - starter files walkthrough
02:31 - connect SQLite database to Flask
04:16 - deploy app to development environment
05:18 - preprocess database data
07:08 - HTML template
08:04 - Jinja2 templating
09:44 - database entries as form options
15:39 - database entries as checkbox elements
18:08 - Flask Session (global data)
24:48 - CSS styling
33:14 - connect JavaScript to Flask
34:46 - JavaScript client side interactions
38:43 - testing the app
39:26 - deploy app to production with Wayscript
41:01 - challenge!
41:17 - thanks for watching!

💻 run Flask locally on Windows machine 💻
---------------------------------------------------------------
⭐ navigate to project directory:
cd path/to/my_directory
⭐ if the name of your Flask Python file is "my_app.py"
set FLASK_APP=my_app
set FLASK_ENV=development
flask run
⭐ in your browser navigate to:
localhost:5000

💻 run Flask locally on Linux machine 💻
---------------------------------------------------------------
⭐ navigate to project directory:
$ cd path/to/my_directory
⭐ if the name of your Flask Python file is "my_app.py"
$ export FLASK_APP=my_app
$ export FLASK_ENV=development
$ flask run
⭐ in your browser navigate to:
localhost:5000

🔗 IMPORTANT LINKS 🔗
---------------------------------------------------------------
⭐ Github Logo from tutorial:
https://raw.githubusercontent.com/Mar...
⭐ my previous Flask tutorial:
   • Simple Web App with Flask and Heroku - Pyt...
⭐ my previous SQLite tutorial:
   • SQLite Backend for Beginners - Create Quic...

🤝 Connect with me 🤝
---------------------------------------------------------------
🔗 Github:
https://github.com/mariyasha
🔗 Discord:
  / discord
🔗 LinkedIn:
  / mariyasha888
🔗 Twitter:
  / mariyasha888
🔗 Blog:
https://www.pythonsimplified.org

🙏 THANK YOU 🙏
---------------------------------------------------------------
Thank you so much for watching! 😀
Thank you to Flaticon for the notes icon: www.flaticon.com

On this page of the site you can watch the video online Flask SQLite Web Application Step by Step Tutorial - HTML, Jinja, CSS, JavaScript, Python with a duration of hours minute second in good quality, which was uploaded by the user Python Simplified 01 January 1970, share the link with friends and acquaintances, this video has already been watched 100,030 times on youtube and it was liked by 2.3 thousand viewers. Enjoy your viewing!

132