SQLAlchemy 2 In Practice: Learn to program relational databases in Python step by step

by Miguel Grinberg

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 product catalogan ordering system with customers, orders and order detailsa product review solution with star ratings and user commentsa page analytics solution that does not rely on third-party servicesAll 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.

274 pages, Kindle Edition

Published April 30, 2023

About the author

Miguel Grinberg has over 25 years of experience as a software engineer and currently leads a team of engineers that develop software for the video broadcast industry. He is the author of the O'Reilly book "Flask Web Development", and blogs about a variety of topics including web development, robotics, photography, and the occasional movie review at http://blog.miguelgrinberg.com. He lives in Portland, Oregon with his wife, four kids, two dogs, and a cat.

Reviews

[Matías Glasner · Rating 4 out of 5]

Very useful book. The examples and very good.