sqlpage-migrate

[andrewsinnovations]

I have a project where the number of database migrations has grown to a decent number.

It was getting out of hand to remember the next number for incrementing.

I created a little node script to automatically generate migrations. It would be great if this were built into sqlpage, but unfortunately I do not know rust well enough to contribute this functionality.

Here's an example:

#> sqlpage-migrate create test_migration 
Created migration: sqlpage\migrations\20250506202808_test_migration.sql

also works:

#> sqlpage-migrate create this is my new migration
Created migration: sqlpage\migrations\20250506205710_this_is_my_new_migration.sql

special characters ignored:

#> sqlpage-migrate create !!!!!test!!!!!
Created migration: sqlpage\migrations\20250506205757_test.sql

It's on npm and you can install it now by running this:

#> npm install -g sqlpage-migrate

The repo is at https://github.com/andrewsinnovations/sqlpage-migrate

[lovasoa]

Cool, thank you ! I'll add the enhancement tag to tag this as a feature request !