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

• https://github.com/dahlia/awesome-sqlalchemy

7.53.8. Alternative ORMs

• Django ORM + Django Migrations 2

• SQLModel 1

• Raw SQL

• SQLObject

• Peewee

• Tortoise ORM

• PonyORM

• Dejavu

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

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

7.53.9. References

1

https://sqlmodel.tiangolo.com

2

https://docs.djangoproject.com/en/stable/topics/db/

3

https://alembic.sqlalchemy.org

4

https://sqlalchemy-continuum.readthedocs.io/