Hello, we are using `alembic check` for this purpose at my daily job. I would be very interested if you could elaborate/give an example on which differences are missed ? (if so, we might have unaligned models & DB schemas without knowing it) Thanks !
Hello, we are using `alembic check` for this purpose at my daily job. I would be very interested if you could elaborate/give an example on which differences are missed ? (if so, we might have unaligned models & DB schemas without knowing it) Thanks !
Excellent question, I should have mentioned it. `alembic check` is nice but it has a lot of blind spots, some of them are actually documented there: https://alembic.sqlalchemy.org/en/latest/autogenerate.html#what-does-autogenerate-detect-and-what-does-it-not-detect
This is why we built this approach, which is designed to be robust and have 0 blind spot by design.
pgmodeler built-in diff is very good as well though gui-based