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

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/