Miguel Grinberg Releases Final Chapter of SQLAlchemy 2 In Practice Book Focused on Web Integration

Miguel Grinberg has published the eighth and final chapter of his SQLAlchemy 2 In Practice book. Released on May 16, 2026 the chapter focuses on applying SQLAlchemy 2.0 in web application contexts with specific examples for Flask and FastAPI.

The publication completes a comprehensive guide that walks readers through SQLAlchemy 2.0 fundamentals from basic setup to advanced relationship handling. Chapter 8 shifts focus to real world web integration addressing a common need for Python developers building data driven applications.

Key topics covered include strategies for managing SQLAlchemy imports to prevent namespace collisions techniques for serializing model instances to JSON for API responses and an introduction to the Alchemical package which streamlines database setup by encapsulating Engine MetaData and Session objects.

The chapter features a complete example application demonstrating server side pagination sorting and searching using the grid.js library. Readers will find detailed walkthroughs of database queries designed to handle complex filtering scenarios alongside framework specific implementations for both Flask routes and FastAPI endpoints.

For Flask developers the example shows how to use Blueprints with automatic session management through Alchemical's Flask integration. FastAPI coverage highlights asynchronous query execution using stream() methods and proper handling of async iterators in response generation.

This release arrives as SQLAlchemy 2.0 adoption continues to grow across the Python ecosystem. By providing concrete patterns for web framework integration the book aims to help developers leverage SQLAlchemy's modern ORM capabilities while avoiding common pitfalls in web application development.

The SQLAlchemy 2 In Practice book is available directly from Miguel Grinberg's store or through Amazon. Readers interested in the companion example code can find it in the associated GitHub repository.