Uploading and Returning Files With a Database in Flask

Uploading files in Flask to a database is very simple to accomplish. In this video, I'll show you to use an HTML upload form to upload files to Flask and save them to blob columns in your database using SQLAlchemy. The example database I'm using is SQLite, but most popular database systems have support for BLOB columns (binary objects).
I'll then show you how to take binary files stored in your database and return them to a client. The database is also accessed using Flask-SQLAlchemy.
Need one-on-one help with your project? I can help through my coaching program. Learn more here: prettyprinted.com/coaching
Get the data model design checklist: prettyprinted.com/datamodelch...
Get the code here: prettyprinted.com/l/iDX
A useful pattern when uploading files: flask.pocoo.org/docs/1.0/patte...
Twitter: / pretty_printed
Github: github.com/prettyprinted

[@mensahbernard3087]

I am a student in software engineering. in my portfolio project i wanted to create a web app that worked with pictures from a sqllite database. This has been the headache of my life till i met this video. Thank you soooooo much bro you don't know how much help you've provided to me God bless you❤️❤️❤️❤️❤️❤️

[@karlduckett]

Thanks Antony - awesome to see you uploading flask content.

[@anthonykarungu1419]

really great tutorial. thanks for the checklist

[@tompis1442]

YESS!!!! Please make a tutorial on how to make a SQLite database when your working with blueprints, there are literally 0 tutorials and guides on the internet. I SEARCHED AND DID NOT FDOUND FOR DAYS!! THANK YOU

[@mithunchandrasaha403]

Nice Explanation,Sir.Needs More.

[@SsaliJonathan]

Wow. I love the way this came out.

[@adamkurek7050]

This video was so helpful, I try to find this tutorial for ages :) but you could show us how should we display the image to the template because the decode is a little bit tricky

[@AL-kw8ic]

thank you very much so helpful

[@aswebdev]

Hi Anthony, What is the best extension to use with flask for REST apis ?

[@mikele951000]

Hi Thanks for your Tutorial! I have an issue while using Python 3.10, the system does not recognize file. read; could be related to version 3.10? Thanks again!

[@donovanmendoza4820]

Thank you! The video is very good! I have a question, how can I download the files from database? :)

[@hoho-sp4cw]

Hey how does it generate the id, I want it to show the id as well after uploading the file.

[@sohbetgurbanov4496]

Hi Anthony! I have a question, how can i upload musics or songs?

[@djohnworthy1040]

I am having hard time trying to check if there is an image in my BLOB or not? How can I achieve this ?

[@ahmedb.r2098]

Cool but how I display the image from the db

[@georlybibas5846]

can i do this with sqlite3 instead of sqlalchemy?

[@cosminw]

Hi cool video. Can you also show a way to store files in file system and store the path in database. Thanks

[@extrem2497]

Is it better to store files as a blob in db or put them in static folder ?

[@comingsoon-zh7wm]

sir how to add Google site verification in flask

[@JeryelBlanco]

I am getting a unciode error when doing this, any suggestions?