Working with a database in Flask with SQLAlchemy

In this section, you will learn how to work with a database in Flask with SQLAlchemy.

Introducing SQLAlchemy

SQLAlchemy is an engine developed in Python that has several components for working with databases. It follows some of the most frequently used patterns for relational object mapping, where classes can be mapped in the database in multiple ways, which allows you to develop the object model and the database schema in an uncoupled way from the very beginning.

SQLAlchemy includes various tools that are focused on interacting with relational databases, among which we can highlight the following:

• SQLAlchemy Core, which allows you to create a generic and independent interface...