Forge SQL migration runners

A comment from Varun back in April (here: Introducing forge-sql-orm: Type-Safe ORM for @forge/sql Using Drizzle - #7 by varun ) said there can be changes of using industry standard migration runners.

I wonder if there is any update on the topic. Thanks!

Hello,

Thanks for checking in! We have something in the works to support standard migration runners like flyway. The main issue(s) that we want to solve are -

  • provide a way to run schema migrations across all installations (databases) of your app
  • support for scheduling DDL requests,
  • Support batching and retries
  • Dev Ex - developers trigger schema migration runs when explicitly required. Additionally, schema migrations are triggered when apps are installed for the first time.
  • End-user observability on the status and history of migration workflows.

We will launch a public RFC with our current thinking and get the community’s feedback on the solution.

Hope this helps!

Varun

1 Like

Thanks for the update! Looking forward to the RFC.