Full Web Apps with FastAPI Transcripts
Chapter: async databases with SQLAlchemy
Lecture: Beta software: See the revisions doc

Login or purchase this course to watch this video and the rest of the course contents.
0:00 I need to put a warning right in front of the beginning of this chapter. We're using the async functionality of SQLAlchemy to unlock the database
0:08 async behaviors in FastAPI. That's awesome, SQLAlchemy is by far the most popular ORM if you are excluding Django ORM, which is tied to Django,
0:18 of course. So it makes sense to use SQLAlchemy. However, as we already saw when we started the previous chapter about the synchronous version,
0:25 the async support is in flux, and we only have a beta version of the API to work with. Now beta, that's not alfa, that's not pre-release,
0:34 that's somewhat stable, right? But at the same time, it's not final. It's, there's no guarantees,
0:40 and it's only a step towards what they're calling the 2.0 version of SQLAlchemy.
0:44 So for that reason, we're going to have to use the beta version of SQLAlchemy. There may be some changes along the way,
0:50 so I wanted to point out that I've created this course revisions document just at the
0:54 top level of the github repository called revisions.md and my goal is to put any changes like you need to make this small code change, or warning,
1:03 we had to change this thing about the way we were working with any of the code
1:07 in the course. But the one that I think we're gonna end up potentially making changes or having any issues around is gonna be this part of SQLAlchemy.
1:15 Be sure to check this document. Right now, you can see it says initial commit no changes, and that's because it's just what we're recording.
1:22 But over time, there might be some issues we run into. I'll update the code in the repository.
1:27 Maybe you run into something. Create a github issue and let me know in the repository, and we'll keep this working will keep it fresh.
1:33 But in order to do this now, instead of waiting months or maybe years in order for the support to be fully there
1:40 we're gonna have to use the beta version. Who knows what's gonna happen in the future so just a heads up on that.

Talk Python's Mastodon Michael Kennedy's Mastodon