Migration files required for DB changes during dev? |
No, autosyncs |
Yes, required |
Yes, required |
Requires schema version number tracking |
No version numbers involved |
Yes, relies on version numbers |
Yes, relies on version numbers |
Must store entire chain of migration files? |
No, only need one file with pending changes |
Yes, required |
Yes, required |
ORMs supported |
Supports any ORM or no ORM |
SQLAlchemy ORM only |
Django ORM only |
Testability |
Explicitly tests for matching schema |
Doesn't test |
Doesn't test |
Needs copy of access to (copy of) current schema to generate migration scripts |
Yes |
No |
No |
Databases supported |
PostgreSQL only |
Postgres, mysql, various others |
Postgres, mysql, various others |