#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.