Table of Contents

Full table of contents. For a high level overview of all documentation, see SQLAlchemy Documentation.

• Overview
• SQLAlchemy ORM
  • Object Relational Tutorial
  • Mapper Configuration
    • Types of Mappings
    • Mapping Columns and Expressions
      • Mapping Table Columns
      • SQL Expressions as Mapped Attributes
      • Changing Attribute Behavior
      • Composite Column Types
    • Mapping Class Inheritance Hierarchies
    • Non-Traditional Mappings
    • Configuring a Version Counter
    • Class Mapping API
  • Relationship Configuration
    • Basic Relationship Patterns
    • Adjacency List Relationships
    • Linking Relationships with Backref
    • Configuring how Relationship Joins
    • Collection Configuration and Techniques
    • Special Relationship Persistence Patterns
    • Relationships API
  • Loading Objects
    • Loading Columns
    • Relationship Loading Techniques
    • Loading Inheritance Hierarchies
    • Constructors and Object Initialization
    • Query API
  • Using the Session
    • Session Basics
    • State Management
    • Cascades
    • Transactions and Connection Management
    • Additional Persistence Techniques
    • Contextual/Thread-local Sessions
    • Tracking Object and Session Changes with Events
    • Session API
  • Events and Internals
    • ORM Events
    • ORM Internals
    • ORM Exceptions
    • Deprecated ORM Event Interfaces
  • ORM Extensions
    • Association Proxy
    • Automap
    • Baked Queries
    • Declarative
      • Basic Use
      • Configuring Relationships
      • Table Configuration
      • Inheritance Configuration
      • Mixin and Custom Base Classes
      • Declarative API
    • Mutation Tracking
    • Ordering List
    • Horizontal Sharding
    • Hybrid Attributes
    • Indexable
    • Alternate Class Instrumentation
  • ORM Examples
• SQLAlchemy Core
  • SQL Expression Language Tutorial
  • SQL Statements and Expressions API
    • Column Elements and Expressions
    • Selectables, Tables, FROM objects
    • Insert, Updates, Deletes
    • SQL and Generic Functions
    • Custom SQL Constructs and Compilation Extension
    • Expression Serializer Extension
    • Visitor and Traversal Utilities
  • Schema Definition Language
    • Describing Databases with MetaData
    • Reflecting Database Objects
    • Column INSERT/UPDATE Defaults
    • Defining Constraints and Indexes
    • Customizing DDL
  • Column and Data Types
    • Column and Data Types
    • Custom Types
    • Base Type API
  • Engine and Connection Use
    • Engine Configuration
    • Working with Engines and Connections
    • Connection Pooling
    • Core Events
  • Core API Basics
    • Events
    • Runtime Inspection API
    • Deprecated Event Interfaces
    • Core Exceptions
    • Core Internals
• Dialects
  • PostgreSQL
  • MySQL
  • SQLite
  • Oracle
  • Microsoft SQL Server
  • Firebird
  • Sybase
• Frequently Asked Questions
  • Connections / Engines
  • MetaData / Schema
  • SQL Expressions
  • ORM Configuration
  • Performance
  • Sessions / Queries
  • Third Party Integration Issues
• Error Messages
• Changes and Migration
  • What’s New in SQLAlchemy 1.3?
  • 1.3 Changelog
  • 1.2 Changelog
  • 1.1 Changelog
  • 1.0 Changelog
  • 0.9 Changelog
  • 0.8 Changelog
  • 0.7 Changelog
  • 0.6 Changelog
  • 0.5 Changelog
  • 0.4 Changelog
  • 0.3 Changelog
  • 0.2 Changelog
  • 0.1 Changelog
  • What’s New in SQLAlchemy 1.2?
  • What’s New in SQLAlchemy 1.1?
  • What’s New in SQLAlchemy 1.0?
  • What’s New in SQLAlchemy 0.9?
  • What’s New in SQLAlchemy 0.8?
  • What’s New in SQLAlchemy 0.7?
  • What’s New in SQLAlchemy 0.6?
  • What’s new in SQLAlchemy 0.5?
  • What’s new in SQLAlchemy 0.4?

Indices and tables

• Glossary

• Index