alembic vs aerich

alembic

A database migrations tool for SQLAlchemy. (by sqlalchemy)

Source Code

Suggest alternative

Edit details

aerich

A database migrations tool for TortoiseORM, ready to production. (by tortoise)

tortoise-orm migration-tool MySQL Postgresql database-migrations ORM

Source Code

github.com

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

alembic		aerich
	Project
4	Mentions	2
2,467	Stars	781
4.4%	Growth	2.7%
8.4	Activity	5.9
5 days ago	Latest Commit	about 1 month ago
Python	Language	Python
MIT License	License	Apache License 2.0

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

alembic

Posts with mentions or reviews of alembic. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-04-17.

Understanding a Data Model
1 project | dev.to | 20 Jul 2022

SQLAlchemy ORM should support comments if you're using it to create database objects.
What migration/versioning tool do you use?
5 projects | /r/PostgreSQL | 17 Apr 2022

https://github.com/sqlalchemy/alembic for python, especially if you're using SQLAlchemy
PostgREST v9.0.0
9 projects | news.ycombinator.com | 29 Nov 2021

Agreed, here’s a link to flyway if anyone is curious - https://github.com/flyway/flyway. Many ORMs come with migration systems in your language of choice. For example, SQLAlchemy’s migration tool is Alembic - https://github.com/sqlalchemy/alembic.
Adding column to DB model results in internal server error, Flask, SQLAlchemy
1 project | /r/learnpython | 28 Nov 2021

aerich

Posts with mentions or reviews of aerich. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-08-14.

FastAPI + Ormar + Alembic setup
7 projects | dev.to | 14 Aug 2021

We have successfully setup out FastAPI + ormar + alembic project. With pydantic support, ormar can generate pydantic models from ormar models. The generated pydantic models can be used by FastAPI during request/response data validation. ormar + alembic is a great duo to writing database code. Another great combination is tortoise ORM + aerich, which I'm planning to write soon.
My Experience Learning Svelte Tailwind Fastapi
1 project | /r/sveltejs | 18 Jan 2021

I also use the source code for aerich a lot. Aerich is similar to alembic but for Tortoise ORM.

What are some alternatives?

When comparing alembic and aerich you can also consider the following projects:

Flyway - Flyway by Redgate • Database Migrations Made Easy.

SQLAlchemy - The Database Toolkit for Python

databases - Async database support for Python. 🗄

fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production

goose - A database migration tool. Supports SQL migrations and Go functions.

pydantic - Data validation using Python type hints

bytebase - The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.

Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

postgresql-migrations - Simple Schema Migrations for PostgreSQL

starlette - The little ASGI framework that shines. 🌟