#100DaysOfCode in Python Transcripts
Chapter: Days 91-93: Database access with SQLAlchemy
Lecture: Introducing SQLAlchemy

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Are you ready to have some fun playing with the database? Well, we're going to talk about an amazing technology called SQLAlchemy.
0:08 And this is probably the best way, and also, probably the most popular way to access relational databases. Previously, you learned about SQLite,
0:18 and SQLAlchemy will of course talk to SQLite, but it'll talk to all kinds of databases. You can find it at SQLAlchemy.org.
0:27 It's an object relational mapper. So when we saw SQLite before, you just created strings, and you said, "Create this table,"
0:34 or, "Select this from wherever." You would write in line SQL, and that was tied to SQLite. Well, SQLAlchemy works in a much higher level.
0:43 What we're going to do is we're going to create classes, and we're going to model the database shape in our classes.
0:50 SQLAlchemy will actually even create the database from the classes, alright? So this is really, really powerful.
0:56 We can point at almost any relational database, and then we work in these high level Python constructs,
1:01 making it very, very easy for us to write the code. We don't have to think in the SQL query language, we just think in Python, and it just works.
1:09 It's up to SQLAlchemy to convert that to the SQL query language. It's really, really easy to get started. It's extremely flexible and powerful.
1:17 And we're going to have a lot of fun building an app with it.

Talk Python's Mastodon Michael Kennedy's Mastodon