Migration tool

[benwoodward]

Outserv really needs a tool or workflow for safely managing migrations.

Ideally it'd have:

• Ability to generate editable migration scripts that can be used to modify the schema and migrate data, or rollback the changes (and the data) if there was a problem
• Scripts would be timestamped in the filenames, and Outserv would be able to run them in sequence, meaning that developers can migrate their local databases with a CLI command after a schema change in the repo
• CLI commands for:
  • generating a new timestamped migration script file and automatically adding it to the migrations directory
  • running the latest migrations
  • rolling back the last run migrations

Existing migration tools for reference:

https://www.edgedb.com/docs/cli/edgedb_migration/index

https://github.com/fauna-labs/fauna-schema-migrate

https://guides.rubyonrails.org/active_record_migrations.html