Flask Tutorial Web Development with Python 13 - MySQL database

Welcome to part 13 of our Flask web development tutorial, in this video we discuss how to incorporate a MySQL database for storing our website's data.

Bitcoin donations: 1GV7srgR4NJx4vrk7avCmmVQQrqmv87ty6

[lcq]

Loving this series !

One question : I'm new to MySQL, and I see that you used it to create a nice set of variables for each user. But because Python is what we know well, couldn't we just store all that data in a python dict containing maybe lists of lists? (like you did earlier in the series when you stored the tutorial pages)

[codewithlenny]

Hello Sentdex is it possible to use Sqlite3 database instead of mySQL??
I am really not comfortable in using MySQL.

[kaplansedat]

please please please don't make tutorial with one table. Please please please do not follow programming courses with one database table. Please please please don't learn programming without sql knowledge. No web app work with one table. Many can say educational purpose than don't use database use csv. and say database is same. but we know its not same. at least two table and use of joins needed.

[sjtgs]

thanks for the tutorial
I have found using flask is much easier to understand if you coming from a django background. Keep up the good work  

[timthacker]

You could install phpmyadmin if you want to make and manage databases through a browser interface. only a couple of simple commands to get it installed and setup i think ( :

Also does anyone know how to make a remote connection from mysql workbench to mysql on a digital ocean server? I couldnt work out how to do it, I think theres some server settings that arent allowing a remote connection.

[propupul]

Hello, here are the steps to reset the password:

[Neceros]

Just so I'm clear, is it possible to stuff anything in those cells? I've been working with mysql for years, but not often.

Could I stick a dictionary or list in there and get it back with proper formatting?

[itclub]

buddy thank you
can we use CMS for Flask
and also i have one question i use python and Node JS how can i use togthere

[lavanyaaddepalli]

It is possible to dynamically post images with flask and bootstrap. i.e. images are generated at certain interval of time and every time a new image arrives in photo bucket (folder) should be pulled and places on from web pages category wise ?

[ShaheerFarooqui]

@sentdex gone through all the videos and got some basic ideas on how to build a flask app. But one quick question is, How to decide which database to use?

[umerbinsiddique]

any way to setup python with MySQL on local windows machine, right now i am learning with virtualenv on local machine.

[smalarvizhi]

sentdex can you suggest a way to search a database

[freddythobhani]

I think username and email should be unique.