Chapter 19: Advanced Database Operations with SQLAlchemy

 

Welcome to Chapter 19, where we will delve into the world of SQLAlchemy, a powerful library in Python that provides a full suite of well-known enterprise-level persistence patterns. It is designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. SQLAlchemy gives application developers the full power and flexibility of SQL and is a perfect choice for handling complex data manipulations and transactions.

The broad goal of this chapter is to help you understand how to interact with databases using SQLAlchemy effectively, covering both its core SQL functionality and the ORM (Object Relational Mapper) layer. By the end of this chapter, ...

Get Python and SQL Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.