Python-powered Chat Apps with Twilio and SendGrid Transcripts
Chapter: Using our database with the SQLAlchemy ORM
Lecture: Database introduction
Login or
purchase this course
to watch this video and the rest of the course contents.
0:02
Everyone was thrilled with the flask app we built. They can't believe how quick all this is coming together, but there's no persistence layer yet.
0:11
We're not really saving any data, are we? And databases are exactly the kind of thing we need. You may have a lot of experience with databases.
0:19
You may be entirely new to databases, but don't worry. In this chapter,
0:22
we're going to use a really cool ORM object relational mapper that lets us write
0:28
plain Python classes and convert those into database tables and database queries.
0:33
We're going to use SQLAlchemy and SQLAlchemy is the most popular way to access
0:38
relational databases in Python. We'll see that we can use the SQLAlchemy to actually generate the tables and then form the queries.
0:47
So even if you're new to working with databases, don't worry. There's not another query, language and definition language, all that kind of stuff.
0:52
You have to learn. We're just going to SQLAlchemy and Python classes, and we'll be of to the races.
0:57
They went around out this chapter by updating the order API and saving those
1:01
new orders coming in from Twilio Studio straight into our database, let's dive-in.