FastAPI Python Tutorial (Part 3) - SQLite Database Design and SQLAlchemy

In this video, we design the database table for our application and hook up SQLAlchemy.

[fairchildSCR]

you are a an excellent instructor. Thanks. Just wish the video was 1080p or better.

[abessesmahi]

Thank you so much.
It will be so nice if you do a tutorial on Database migration in FastAPI project.

[perfecto]

great stuff. Im playing around with Gino, looks perfect for fastapi, its async SQL ORM and interface is very pythonic, unlike sqlalchemy, will let you know if production capable.

[gilmcglory]

I agree with Ravi and would like a tutorial on using MySQL. Thanks so much for your help.

[ewaschenko]

When trying this I'm getting an error ModuleNotFoundError: No module named 'models'. I;ve added the __init__.py file too

[ravishankar]

can you please make a video on how to connect to MySql database connection using FastApi?

[jnana]

Thanks for the video.How can I insert records into an existing table?

[DataMan]

Great tutorial. Thanks for sharing. Not sure if it was mentioned in the video but Sqlite3 is part of base Python.

[stansuen]

I know it's not fair to ask help for debugging through youtube comment but I got a strange one. I got the whole thing running as per the video but VSCode shows an error that "unable to import models" on main.py 1st line. However the stocks.db was created successfully and everything works well. I am a beginner of python. Do you guys have any idea as to why this error occurs? Perhaps it's not a strange thing to the experienced eyes.

[santigutierrez]

What if you have your models split up in multiple files? How would we deal with that?

[donpaul]

Hi Larry, what theme are you using? I have found the Python syntax themes to be awful. And seems like trying to change the colors for various objects in Python is non-trivial...

[groot]

Thank you so much.
I following the tutorial but my stock.db was not create and my cmd does not show any error help pls I use Window10

[ionut-alexandrubacalu]

hello Larry, great tutorials...I have a question...if we want to add multiple fields for the instruments (e.g. longName, trailingEPS etc) - how can we update the db schema without having to remove the .db everytime we add a new attribute? Many thanks!

[GeorgiStoyanov]

am I the only one who is irritated by the presumption of Larry, that everyone who is watching this video should have a Mac?