We have built projects where we used python Alembic or Ruby's Activerecord migrations to manage the db.
The actual application was in Go or nodejs.
I daresay that Activerecord and Alembic outclass Liquibase in a lot of things.
The actual application was in Go or nodejs.
I daresay that Activerecord and Alembic outclass Liquibase in a lot of things.
Some technical benefits to Alembic:
- It will give you the structure for upgrades and downgrades.
- Has a clean interface for DDL operations
- Supports every (?) database that SA does
- You can use it in "Offline" mode if you don't want to have Python and all the dependencies on the server or have to hand the migration off to someone else that has access.
- The branch feature is really nifty if you are in advanced situations.
Some non-technical benefits with Alembic
- It is open source
- zzzeek, the author, is pretty active on here and has built both SQLAlchemy and Alembic so there is a lot of cohesion in styles.
- The issue tracker is active and responsive
- The code is stable (something you want in a migration tool) and is unlikely to go anywhere.
Highly recommend.
Edit: Formatting