IMO, hand migration scripts are the single best way to manage schema changes with the database. Some tools will allow separate directories for lists of stored procedures, functions etc. Separate from schema/migration scripts.
With numbered migrations, you are much less likely to experience issues managing an application that is deployed into many environments.
Worth looking into, though not JS specifically is the Dotnet tool "Grate", which is a successor to RoundhousE. The cross db support is very good. If anyone knows of a comparable project for Node/Deno, would be happy to see/hear it. For that matter, it might be interesting to see something in a single executable in Go or Rust. But so far Grate is about the best option I've found.
- https://github.com/erikbra/grate
tracker1 6 days ago. link 1 point ▲ ▼