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.

[mensahbernard]

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 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.

[anthonykarungu]

really great tutorial. thanks for the checklist

[adamkurek]

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

[donovanmendoza]

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

[tompis]

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

[aswebdev]

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

[mikele]

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!

[hoho-spcw]

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

[sohbetgurbanov]

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

[extrem]

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

[cosminw]

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

[pacoluna]

Hi Anthony! i have a doubt, i hope you can help me. For developing you use a local db file, but when you lunch your app to production, how you connect a real time database? That would be cool for a video

[bryanchacha]

Please help i get an error data too long if i upload a bigger image. any help??

[georlybibas]

can i do this with sqlite3 instead of sqlalchemy?

[ahmedb.r]

Cool but how I display the image from the db

[Kennethlumor]

Sir please please and please I'm a final year student and I developed E-learning management systems using flask but how to add a search system is now my problem

[comingsoon-zhwm]

sir how to add Google site verification in flask

[djohnworthy]

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

[songokussjcz]

What would you recommend as a largest size for this to work. (either SqlLite, PostgreSQL or MSSQL]. I have files at work which are 2 GB big. Is it better to store them somewhere on the server and then save only the path to them?