I mentioned it before on reddit but since I just released a new version working with MySQL as well, might be worth putting it here.
This is a tool heavily inspired by a Go tool I’ve used: migrate and django migrations.
In short, a migration involves 2 sql files, a
up and a
down which are plain SQL and are executed depending on what you want do (running
dbmigrate up will run all the
up migrations not done yet in order for example).
This currently supports PostgreSQL and MySQL, adding a driver is not too hard so let me know if there’s another database that could use it.
Also looking for feedback on needed commands I don’t have implemented yet and general code review.