8.53. SQLAlchemy Extensions

8.53.1. Schema Versioning

  • Alembic [3]

  • Alembic-utils

8.53.2. Data Versioning

  • Papertrail

  • Sqlalchemy-continuum [4]

8.53.3. Data Types

  • sqlalchemy-enum (Enum support is already in SQLAlchemy)

8.53.4. Forms

  • formalchemy

8.53.5. GIS and Spacial Data

  • GeoAlchemy

  • GeoAlchemy2

8.53.6. Profiling

  • SQLtap

  • nplusone

8.53.7. Further Reading

8.53.8. Alternative ORMs

  • Django ORM + Django Migrations [2]

  • SQLModel [1]

  • Raw SQL

  • SQLObject

  • Peewee

  • Tortoise ORM

  • PonyORM

  • Dejavu

../../_images/sqlalchemy-about-alternatives.png

Figure 8.8. ORM software popularity in Python community [#PythonDeveloperSurvey2020]_

../../_images/sqlalchemy-about-databases.png

Figure 8.9. Database popularity in Python community [#PythonDeveloperSurvey2020]_

8.53.9. References