Adding a CMS to Your Pyramid Web App Transcripts
Chapter: Saving content to a database
Lecture: Introducing SQLAlchemy

Login or purchase this course to watch this video and the rest of the course contents.
0:00 For a long time we've been using our fake database, which is transient.
0:05 It keep stuff in memory, but every time you restart the app, it goes away, and it's not a real database. So we're going to fix that in this chapter.
0:13 What we're gonna do is work on saving pages and redirects and maybe even other information to a database. We're going to use SQLAlchemy
0:22 SQLAlchemy is an ORM or object relational mapper, and it's by far the most popular way to talk to databases using Python.
0:30 It's been around for a long time. It's very polished, and it's actually what we're already using for most of the website.
0:37 Remember, you saw we have these packages that were listed there make it big in the details.
0:42 We even talked about the difference between data-driven pages and CMS pages.
0:46 All those data different pages are already handled with SQLAlchemy and already stored and managed in the database.
0:53 So what we're gonna do is actually just add on to our existing database model,
0:58 so we'll start by doing a quick tour of the data model as it is, and then we'll add the few extra things we need to store pages and redirects in our

Talk Python's Mastodon Michael Kennedy's Mastodon