Books & Videos

Table of Contents

  1. Chapter 1 Introduction to SQLAlchemy

    1. What Is SQLAlchemy

    2. The Object/Relational “Impedance Mismatch”

    3. SQLAlchemy Philosophy

    4. SQLAlchemy Architecture

  2. Chapter 2 Getting Started

    1. Installing SQLAlchemy

    2. SQLAlchemy Tutorial

  3. Chapter 3 Engines and MetaData

    1. Engines and Connectables

    2. MetaData

  4. Chapter 4 SQLAlchemy Type Engines

    1. Type System Overview

    2. Built-in Types

    3. Application-Specific Custom Types

  5. Chapter 5 Running Queries and Updates

    1. Inserts, Updates, and Deletes

    2. Queries

  6. Chapter 6 Building an Object Mapper

    1. Introduction to ORMs

    2. Declaring Object Mappers

    3. Declaring Relationships Between Mappers

    4. Extending Mappers

    5. ORM Partitioning Strategies

  7. Chapter 7 Querying and Updating at the ORM Level

    1. The SQLAlchemy ORM Session Object

    2. Querying at the ORM Level

    3. Contextual or Thread-Local Sessions

  8. Chapter 8 Inheritance Mapping

    1. Overview of Inheritance Mapping

    2. Single Table Inheritance Mapping

    3. Concrete Table Inheritance Mapping

    4. Joined Table Inheritance Mapping

    5. Relations and Inheritance

  9. Chapter 9 Elixir: A Declarative Extension to SQLAlchemy

    1. Introduction to Elixir

    2. Installing Elixir

    3. Using Elixir

    4. Elixir Extensions

  10. Chapter 10 SqlSoup: An Automatic Mapper for SQLAlchemy

    1. Introduction to SqlSoup

    2. Using SqlSoup for ORM-Style Queries and Updates

    3. Using SqlSoup for SQL-Level Inserts, Updates, and Deletes

    4. When to Use SqlSoup Versus Elixir Versus “Bare” SQLAlchemy

  11. Chapter 11 Other SQLAlchemy Extensions

    1. Association Proxy

    2. Ordering List

    3. Deprecated Extensions

  1. Colophon