ORM Examples — SQLAlchemy 2.0.0b1 documentation

From Get docs

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


Asyncio Integration

Directed Graphs

Dynamic Relations as Dictionaries

Generic Associations

Large Collections

Materialized Paths

Nested Sets


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