Add migrations with multiple SQL files

mojolicious / mojo-pg

Mojolicious :heart: PostgreSQL

https://metacpan.org/release/Mojo-Pg

Artistic License 2.0

99 stars 46 forks source link

Add migrations with multiple SQL files #71

Closed kraih closed 3 years ago

kraih commented 3 years ago

The single file approach can get messy very quick if you have too many migrations. There should probably be another option where it uses a directory with multiple SQL files.

migrations/1/up.sql
migrations/1/down.sql
migrations/2/up.sql
migrations/3/up.sql
migrations/3/down.sql

Maybe like that. We'll have to see what works best for keeping many migration steps around.

jhthorsen commented 3 years ago

This is resolved by #72