Migrations into subdirectories (readdir recursive directory search)

[nepster-web]

this function looks weak:
https://github.com/salsita/node-pg-migrate/blob/master/src/migration.ts#L46

Is it planned to support nested directories in the migrations folder?

for example:

[ruiwei]

It would be nice to support subfolders.

[mythmon]

Would you take a PR To add this feature? On my project we've been using node-pg-migrate for several years, and have nearly 500 migrations now. It's getting a bit annoying to scroll through all the migration files when editing code. I'd love to be able to put a migration file like 20240624172531774_add-new-table.sql (using utc prefix) into a subdirectory like 2024/20240624172531774_add-new-table.sql (or maybe 2024/0624172531774_add-new-table.sql)

[Shinigami92]

@mythmon As I expect this does not introduce breaking changes, you can start with a PR 😸

[benkroeger]

I think this issue can be closed. the suggested feature is fully included since glob support for migration file selection in #1274

also, , I believe that these concerns are covered. as long as you keep the file names with utc timestamp intact - you can freely reorganize them within your glob-pattern