Learn how to build a basic social platform with the Python Flask web framework. In this video we review how to create a database, pull data in and out of that database, create a web server with python, and use python HTML templating to render a page for the user!
Tutorial created by John G. Fisher. Watch more great tutorial from John on his YouTube channel:
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
This Post Has 21 Comments
Thanks for sharing this with everyone, hope you guys enjoyed it! Happy to answer any questions you guys might have below.
@John G. Fisher Unable to execute sqlite3 database.db < schema.sql. Using powershell on win10. The error that I get, "The term 'sqlite3' is not recognized as the name of a cmdlet, function, script file, or operable program"; while with cmd the error that I get is "'sqlite3' is not recognized as an internal or external command,
operable program or batch file.". Does sqlite3 not come preinstalled with Python?
Cool video. Would it be able to use this as an actual social network app, so that you could connect to it from another computer?
Really liked the debugging at the end.
Why virtualenv isn't working on my windows? and where to find way to fix this problem?
and also you typed as virtualenv –python=python3.9
output: there is a issue error message?
I also interect with this thing ls is this a linux is using it for? because im trying to use it on windows but it doesn't let me know to enter it properly…
lastly, im still confused in the virtualenv creating the file into your folder net
im stuck here please help
Using windows 10. (vi schema.sql) gives an error "'vi' is not recognized as an internal or external command,
operable program or batch file."
i'm so much taking up flask…thanks to you…your content is legit
For windows users, run "myenvscriptsactivate.bat" instead of "source myenv/bin/activate"
Very beautifully explained each and every functionality, thanks for sharing, keep up the good work
bash: sqlite3: command not found
I got this error, Im using GIT bash in vscode
Debugging the code and rectifying the errors in the end. Man I enjoyed that part.
Something like this I want it.
Hello,thanks for the video. Where do you create this code at the beginning? i couldn't understand.
please disable pylint next time
nothing at the beginning works in my console except the pip install.
Can anyone help me solve it, please (Im using windows 11):
PS C:Usersphanhnet> vi schema.sql
vi : The term 'vi' is not recognized as the name of a cmdlet,
function, script file, or operable program. Check the spelling
of the name, or if a path was included, verify that the path is
correct and try again.
At line:1 char:1
+ vi schema.sql
+ CategoryInfo : ObjectNotFound: (vi:String) , Co
+ FullyQualifiedErrorId : CommandNotFoundException
Great video man. Helped me a lot.
When I run I get an error : sqlite3.OperationalError
sqlite3.OperationalError: no such table: post
Does anybody know what I am doing wrong?
CORS is not going to protect you from Cross Site Scripting (XSS) or SQL Injection (SQLi), CORS is just used to prevent or allow Cross-Origin Resource Sharing from specific domains. if you want to be secured from XSS and SQLi you just want to make sure what is being displayed (in case of xss) or what goes into database (in case of sqli) is properly filtered.
look how fast he find the errors! awesome man
Got this error :
'vi' is not recognized as an internal or external command,
operable program or batch file.
When trying to create database file.