ORM
Object Relational Mapping (ORM) is a programming technique that allows the developer to map objects in the programming language to the data model in a database. There is no longer any need to use SQL to interact with a database. The benefit of this is that developers can code in their own programming language and it will work on different types of databases.
The mapping works along the following lines:
- Class in Python = the table schema in the database
- Attributes in a class = fields in the table schema
- Objects = rows of data in the table
SQLAlchemy is the most popular ORM in the Python community. Next, let's delves further by attempting to create a database.
Exercise 18: Setting Up a Smilecook Database
Most applications nowadays require a database to store and manage data. Our application, Smilecook, is no exception. It is a recipe-sharing platform and is open to the public. Obviously, it will have to store the user data and recipe data. In...