What was the purpose of using Alembic?

Alembic is a tool for managing database migrations in Python projects, especially with SQLAlchemy.

The main purpose of Alembic is to automate the process of schema changes in the database as the application develops. With it, you can:

• Create and apply migrations that describe changes in the structure of tables, indexes, constraints.
• Version the database schema so you can roll back to a previous state.
• Ensure schema consistency across different development, testing, and production environments.

An example of usage: when adding a new field to a model, an Alembic migration is created, which updates the table in the database without data loss.