For my (elixir) (dev/demo) application I went a bit on a rampage and have changed the database structure of my app.
It would be easier for me to have a new database rather than migrating everything around, but I’m not sure how best to do this without deleting the entire fly app.
Can I just get away with deleting the database with psql and make a new one? Does fly have any special settings to the database it applies that id need to recreate?
I recreated it a few times and usually I just delete the app and create a new one, it seems the simplest way, also because if you created/updated user roles you might need to change those as well while if you drop the app you are sure you start from 0…just remember that the app connected to the db must scale to 0 otherwise the app cancellation might fail as the db as active connections
I have tried this previously but as my application has the same name, sometimes I believe the DNS records don’t get updated correctly as although the application says it’s running I can’t access it via the url.
If I recreate the app again it has a better chance of working, but I wasn’t sure if I was being a bit cheeky by doing this.