How to migrate database in production?

[Barbapapazes]

Hello ! 👋

In the documentation, you talked about the migration in development with 2 recipes page but there is nothing about migrations in production!

Could be great to know how an application using database must be published! Do you recommend to manually add SQL file in the Cloudflare UI or to use the Cloudflare CLI locally or in a custom CD? Thanks!

[atinux]

So far I actually apply the migration by running the development server with --remote so it automatically apply the migration when starting the server to the production or staging database.

You can also run the SQL query in your database dashboard or on Cloudlare UI as well.

Later I wish to be able to leverage Nitro Tasks with a UI to be able to run those in production with a button.

[atinux]

Database migrations is out!

https://hub.nuxt.com/changelog/database-migrations

[Barbapapazes]

Database migrations is out!

https://hub.nuxt.com/changelog/database-migrations

Love it! 👌