Full Web Apps with FastAPI Transcripts
Chapter: Storing data with SQLAlchemy
Lecture: Need to learn SQLAlchemy? See the appendix
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
When I introduced this chapter, I said, you're familiar with this SQLAlchemy API and we're going to start that way.
0:07
Well, what if you aren't familiar with it? What if you need to learn SQLAlchemy? Maybe you're brand new to databases.
0:13
Well, there's a couple of things you can do. One, you can just sit back and let it wash over you and kind of
0:17
get an appreciation and some initial exposure to what we're doing. Or if you want to make sure you dive in, you wanna do a little extra work,
0:25
I'm going to actually put an appendix that you can go study first, before we jump
0:30
in to actually writing the code. If you look over on the Talk Python Training
0:34
site, we have a class called "Building Data-Driven Web Apps with Flask and SQLAlchemy". In this course, we built PyPI from scratch
0:42
but way, way deeper into the web design, the web development foundations across everything.
0:48
Remember, this is about teaching you how to do that kind of stuff with FastAPI, not how to teach you how to do it from absolute no understanding,
0:55
which is kind of what this course does. And if you look down here, you can see we've got chapter 9 and 10, "Modeling data
1:03
with SQLAlchemy classes" and then doing basically queries, inserts and updates with SQLAlchemy as chapter 10. It's almost two hours of content,
1:12
I'm going to take those two chapters and put them into appendices at the end of
1:16
the course. If you're really wanting to go slow and take everything in and SQLAlchemy this is your first exposure to it.
1:25
Then go ahead and watch those two appendices, those two chapters. Not only will they teach you SQLAlchemy in the context of web development,
1:32
they will teach you SQLAlchemy building PyPI. So, in fact, the data model is identical. So in this course we built pypi.org from scratch,
1:41
using much of the same constructs. And over here, when we talk about SQLAlchemy, we're talking about the same thing users,
1:47
packages, releases and so on. So you'll get a really good foundation for what we're gonna do with SQLAlchemy over here
1:53
if you'd like to spend an extra couple hours digging into the foundations. If you're familiar with it, you probably don't need to do this,
1:59
but if your brand new, your time is probably well spent over here going through the two appendices before we go further.