Table of Contents

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

• Overview
• SQLAlchemy 1.4 / 2.0 Tutorial
  • Establishing Connectivity - the Engine
  • Working with Transactions and the DBAPI
  • Working with Database Metadata
  • Working with Data
    • Inserting Rows with Core
    • Selecting Rows with Core or ORM
    • Updating and Deleting Rows with Core
  • Data Manipulation with the ORM
  • Working with Related Objects
  • Further Reading
• SQLAlchemy ORM
  • Object Relational Tutorial (1.x API)
  • Mapper Configuration
    • Mapping Python Classes
    • Mapping Classes with Declarative
      • Table Configuration with Declarative
      • Mapper Configuration with Declarative
      • Composing Mapped Hierarchies with Mixins
    • 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
    • Late-Evaluation of Relationship Arguments
    • Adjacency List Relationships
    • Linking Relationships with Backref
    • Configuring how Relationship Joins
    • Collection Configuration and Techniques
    • Special Relationship Persistence Patterns
    • Relationships API
  • Querying Data, Loading Objects
    • ORM Querying Guide
    • 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 queries, object and Session Changes with Events
    • Session API
  • Events and Internals
    • ORM Events
    • ORM Internals
    • ORM Exceptions
  • ORM Extensions
    • Asynchronous I/O (asyncio)
    • Association Proxy
    • Automap
    • Baked Queries
    • Declarative Extensions
      • Declarative API
      • Basic Use
      • Declarative Inheritance
      • Mixin and Custom Base Classes
      • Configuring Relationships
      • Table Configuration
    • Mypy / Pep-484 Support for ORM Mappings
    • Mutation Tracking
    • Ordering List
    • Horizontal Sharding
    • Hybrid Attributes
    • Indexable
    • Alternate Class Instrumentation
  • ORM Examples
• SQLAlchemy Core
  • SQL Expression Language Tutorial (1.x API)
  • SQL Statements and Expressions API
    • SQL Expression Language Foundational Constructs
    • Column Elements and Expressions
    • Operator Reference
    • 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
    • Core Exceptions
    • Core Internals
  • SQLAlchemy 2.0 Future (Core)
• Dialects
  • PostgreSQL
  • MySQL and MariaDB
  • 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.4?
  • Migrating to SQLAlchemy 2.0
  • 1.4 Changelog
  • 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.3?
  • 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