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.


Talk Python's Mastodon Michael Kennedy's Mastodon