I cannot find a simple way to drop the database and rerun seeds/migrations without having to basically blow away the postgres app, delete associated secret keys, recreate postgres app and redeploy. Then I have to CLI into the app and manually run my seeds.
Locally for a Phoenix app this would just be mix ecto.reset. Does Fly really not have any dev tooling to enable these?
I’d argue this isn’t a platform problem, it’s an application-level one. For my Laravel app, CircleCI runs a post-deploy script, which includes a migration via the Laravel command artisan. It uses a database table to maintain its last migration position, so it will do a no-op if there are no migrations to run.
Ah, if the command you’ve specified is all you need, then can you not just trigger it via your CI flow? Use flyctl ssh console --command /path/to/your/post-deploy-script.sh.