Anvil: Web Apps With Nothing but Python Transcripts
Chapter: Databases: Storing and querying data
Lecture: Introducing data tables

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Almost every meaningful web application has some form of database. If you going to log in and have an account
0:08 if you're going to have a listing of items even a blog post probably has some form of database.
0:14 Now, simple blogs, they might have just have files on disk or maybe somethin' like SQLite but real web applications, they have database servers.
0:24 This might be Postgres, it might be MongoDB. When you work with those there's a lot of things you have to consider.
0:30 How am I going to talk to the database? Will I use the SQL query language? Will I use an ORM that maps classes into that database?
0:39 How will I make sure that the web server is properly connected and securely connected to the database server machine and the database itself?
0:48 All these things can be challenging. Luckily, Anvil's packaged the web app and the database together and they're already wired up
0:57 and ready to talk to each other. So this is really great. You'll see that workin' with databases in Anvil is, well, it's almost transparent.
1:04 In this case that's a good thing.


Talk Python's Mastodon Michael Kennedy's Mastodon