Python FastAPI Tutorial: How to Connect FastAPI to Database 

Glad you enjoyed it! Good luck within your FastAPI journey :-)

You're awesome! Thanks :-)

I am glad you enjoyed it! 😊

Awesome! Glad you are here!

I am glad you enjoyed it :-)

It will 🙂

Thanks for the kind words! You’re the best. Is there anything you want to see in a future video regarding FastAPI?

@@codingwithroby Yep, a whole series would be great, your way of teaching is really good. Topics like authentication, background tasks etc. would be nice really.

Thank you! I am glad you are here :-)

Not a bad idea!

Glad you found it useful :) thanks for watching

Hey friend, check out my full course on the subject :-) www.udemy.com/course/fastapi-the-complete-course/

Thanks friend!

hello please

You can, but it would be better to keep the validation separate from the database models

Hmm interesting, I will take a look at the Quart framework. Is this something you use often?

​@@codingwithroby I have been using Flask for some time, has been contemplating to migrate to Quart due to its native async capabilities...but hesitated due to very limited extension ecosystem compared to Flask. But a couple of months back there's a new development: a library called quart-flask-patch (written by the author of Quart himself) which enables a lot of the most important Flask extensions to be used in Quart. ~ so essentially what "crippled" Quart's potential has disappeared.. I deployed a test page of Quart last week and the async works so good I don't think I would ever go back to a synchronous framework.

Try something similar to: f = Foo(bar=x) session.add(f) session.flush() # At this point, the object f has been pushed to the DB, # and has been automatically assigned a unique primary key id f.id # is None session.refresh(f) # refresh updates given object in the session with its state in the DB # (and can also only refresh certain attributes - search for documentation) f.id # is the automatically assigned primary key ID given in the database.

Which part are you referring to? Like the opening and closing of the database connection?

You're so welcome!

I’m starting a new series currently on passing coding interview questions. I have multiple videos lining up! First one will be released this week :)

Pydantic model is for the request coming in. It will do data validation. SQLAlchemy model is for the actual record in the database. Not all requests will match the model in the database exactly the same - in small applications like this sure, but it is best to have them separated 🙂

@@codingwithroby Thanks :) I just skimmed the fastapi docs on relational DBs and found out about ORM mode. Also the seperation of concerns clicked for me when I compared it to a Django model with a DRF serializer.

do you have solution now

@@spider279 Actually, I made a silly mistake lol. So in models.py instead of ... title = Column(String) ... I wrote ... title : Column(String) ... also in all other fields. This is why there are no fields created in books.db, except ID field

Glad you were able to figure it out :-)

I am not familiar with the term "level 3 Rest" - what is that?

Thanks a bunch!

Thank you!

Ohhh, great idea.

Thanks for the feedback

It can anything you want it to be. Int, String, UUID you choose :)