SQLAlchemy 2 In Practice

SQLAlchemy 2.0 In Practice introduces Python developers to the latest version of the SQLAlchemy relational database framework, by building a non-trivial database project from the start and in small incremental steps. Following this book's guidance, you will build a database for a made-up online business that sells retro home computers of the 1980s and 1990s. As part of this project you will learn how to build:

a product catalog

an ordering system with customers, orders and order details

a product review solution with star ratings and user comments

a page analytics solution that does not rely on third-party services

All chapters include abundant examples of database queries, along with exercises for the reader to work on (solutions to the exercises are provided).

For developers interested in using SQLAlchemy in larger applications, information and examples on integrating databases into web applications written with the Flask and FastAPI frameworks is provided. A chapter dedicated to the use of SQLAlchemy 2 in asynchronous applications based on the asyncio package is included as well.

Miguel Grinberg has over 25 years of experience as a software engineer. He blogs at https://blog.miguelgrinberg.com about a variety of topics including web development, Python, JavaScript, robotics, photography and the occasional movie review. Miguel lives in Ireland. Follow @miguelgrinberg on Twitter.