Summary

In this chapter, we extensively discussed SQL and relational data modeling for the web. A relational database helps us with the design of a database as a group of relations. We also discussed relationships that can exist in a database, such as one-to-one, one-to-many, and many-to-many relationships, allowing us to logically group relations in the database and enforce data referential integrity.

Additionally, we examined how to set up PostgreSQL. We shed light on the basics of SQLAlchemy and its associated database adapters and how they are used in Flask application development. We discussed data model design, with the Bizza project as a use case. Finally, we discussed how a Flask app can communicate with the database and migration in Flask to keep track of changes in a database.

In the next chapter, we will extensively discuss the API in backend development and how you can use the Flask framework to implement API design.