Web Apps with web2py: Database Connectivity & the Model

Database connectivity is a crucial part of any full-stack web application and is the most convenient manner to persistently store data like user login credentials. web2py is built on the Model-View-Controller (MVC) paradigm with the model focused on connecting to databases and managing data in external sources. In this course study the role of the model in web2py apps. Investigate the db.py file and learn how to integrate MySQL with web2py while using the MySQL database as a backend for your web apps. Next explore how to install the MySQL server and MySQL Workbench tool and practice integrating web2py with these technologies. Finally work with the SQLFORM.grid widget which is an extremely powerful and simple way to work with data from the model and incorporate it into your app.