7.53. SQLAlchemy Extensions

7.53.1. Schema Versioning

  • Alembic [3]

  • Alembic-utils

7.53.2. Data Versioning

  • Papertrail

  • Sqlalchemy-continuum [4]

7.53.3. Data Types

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

7.53.4. Forms

  • formalchemy

7.53.5. GIS and Spacial Data

  • GeoAlchemy

  • GeoAlchemy2

7.53.6. Profiling

  • SQLtap

  • nplusone

7.53.7. Further Reading

7.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 7.13. ORM software popularity in Python community [#PythonDeveloperSurvey2020]_

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

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

7.53.9. References