Having taken a closer look at DBIx::Migrations::Directories, I've decided that I want to write my own migration tool for Perl/ORM (likely tied to Rose::DB::Object, but not necessarily). Any thoughts on how the interface should look? I'm modeling functionality at least partially on ActiveRecord from Rails.

I'm leaning towards something along the lines of having a standard migrations directory in the application with numbered migrations in the format

001.create_user_table.m
001.create_data_table.m
002.add_permissions_to_users.m
...
[download]

Within a migration you'll have something along the lines of:

sub UP {
  create_table(
                        name => 'users',
                        key => 'id',
                        fields => {
                             id => 'integer',
                             username => 'string(40)',
                             password => 'string(20)',
                             displayname => 'string(60)',
                                          },
                       );
}

sub DOWN {
    drop_table('users');
}
[download]

Although the specifics are still up in the air. I'd appreciate everyone's feedback on this.