For example, I want to connect to different CockroachDB region from different Fly region, can I set different DATABASE_URL secrets for different Fly regions?
There’s now way to do this now. But you could map the regions to the Cockroachdb addresses in your application, before it initializes the database connection. Here’s where it’s done in the fly-ruby gem in a Rails application.