I suggest you ...

Do something when Heroku app's DATABASE_URL changes

If you promote a database in Heroku:
https://devcenter.heroku.com/articles/heroku-postgresql#specifying-and-promoting-databases

Then the database URL in DbInsights is not automatically updated, nor are you notified that a change has happened. You can manually set the new DB URL in settings no trouble, but that requires you to realize what's happened.

In my case a collegue performed a required fast changeover, which resulted in out DbInsights data going stale.

If you can get this from Heroku, if might be nice to check it and throw up a flash if they don't match.

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Dave Tapley shared this idea  ·   ·  Admin →
    declined  ·  AdminIvan Schneider (Developer, DbInsights) responded  · 

    Thank you for your suggestion.
    The only way DbInsights could know that the DATABASE_URL is not in sync anymore would be by requiring the user to provide her Heroku account API key (in order to be able to go check the application’s configuration variables).
    However the Heroku account API key also gives a lot more permissions and since this is not strictly necessary for DbInsights, I think that would be too intrusive.

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base