I see a lot of folks are using release_command in the fly.toml, but is anybody out there using database user with different permissions for migrations and regular app usage (SELECT, INSERT, UPDATE, DELETE, etc).
How are you handling using a different config than the regular DATABASE_URL
secret/env var?
I set up a secret DATABASE_URL_OWNER
, but I don’t know the most reasonable way to use it. I’d like to overwrite DATABASE_URL
,but only in the context of running the migration command.
I could make make a separate config for my database to handle it, but if there’s a another way to alias the secret in a secure way for one command, that’d be nicer.