nuxt-hub / core

Build full-stack applications with Nuxt on CloudFlare, with zero configuration.
https://hub.nuxt.com
Apache License 2.0
902 stars 50 forks source link

How to migrate database in production? #100

Open Barbapapazes opened 4 months ago

Barbapapazes commented 4 months ago

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 commented 4 months ago

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.