ORM Examples¶

The SQLAlchemy distribution includes a variety of code examples illustrating a select set of patterns, some typical and some not so typical. All are runnable and can be found in the /examples directory of the distribution. Descriptions and source code for all can be found here.

Additional SQLAlchemy examples, some user contributed, are available on the wiki at https://www.sqlalchemy.org/trac/wiki/UsageRecipes.

Mapping Recipes¶

Adjacency List¶

Associations¶

Asyncio Integration¶

Directed Graphs¶

Dynamic Relations as Dictionaries¶

Generic Associations¶

Large Collections¶

Materialized Paths¶

Nested Sets¶

Performance¶

Relationship Join Conditions¶

Space Invaders¶

XML Persistence¶

Versioning Objects¶

Versioning with a History Table¶

Versioning using Temporal Rows¶

Vertical Attribute Mapping¶

Inheritance Mapping Recipes¶

Basic Inheritance Mappings¶

Special APIs¶

Attribute Instrumentation¶

Horizontal Sharding¶

Extending the ORM¶

ORM Query Events¶

Dogpile Caching¶

PostGIS Integration¶

Alternate Class Instrumentation

SQLAlchemy Core