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.