database.env.yml

<%
  # default database without credentials, suffixed with env
  def default_database(env)
    "postgres://localhost:5432/openproject_#{env}?encoding=unicode&pool=5"
  end

  # first checks if there's an env var defining the database
  # then falls back to using the default database for the env
  def database(env)
    ENV.fetch('DATABASE_URL') { default_database(env) }
  end
%>

default: &default
  url: <%= database(Rails.env) %>

development:
  <<: *default

test:
  <<: *default

production:
  <<: *default