Mastering Flask Web Development - Second Edition

Creating Models with SQLAlchemy

As we saw in the last chapter, models are a means of abstracting and providing a common interface to access data. In most web applications, data is stored and retrieved from a relational database management system (RDBMS), which is a database that holds data in a tabular format with rows and columns and is able to implement a relational model with data across tables. Some examples include MySQL, Postgres, Oracle, and MSSQL.

In order to create models on top of our database, we will use a Python package named SQLAlchemy. SQLAlchemy is a database API at its lowest level, and performs object relational mapping at its highest level. An ORM (object relational mapper) is a tool that allows developers to store and ...