How should I connect to Heroku Postgres db from an external server?

Question

It states here that it's not a good practice to connect to a heroku db using a URL like this:

postgres://$user:$pass@$db_host.com:5432/$db_name

But you should rather "fetch the database URL config var from the corresponding Heroku app when your application starts" like this:

DATABASE_URL=$(heroku config:get DATABASE_URL -a your-app) your_process

I want to connect to a heroku db from an external (outside heroku) node server using sequelize. How should I do that?

const db = new Sequelize(DATABASE_URL, {
  logging: false,
  pool: {
    max: 15,
    min: 5,
    idle: 10000,
    acquire: 10000,
  },
  dialectOptions: {
    ssl: {
    require: true,
  },
 },
 ssl: true,
});

filiprem · Accepted Answer · 2020-04-17 15:05:32Z

1

With Heroku CLI, you would use heroku config:get DATABASE_URL. To do the same thing programmatically, consult the Heroku documentation which states:

You can manage your app’s config vars programmatically with the Heroku Platform API using a simple HTTPS REST client and JSON data structures. You need a valid Heroku access token representing a user with proper permissions on the app.

The details of REST API for config vars is described in the platform API reference.

answered Apr 17, 2020 at 15:05

filiprem

7,2131 gold badge34 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How should I connect to Heroku Postgres db from an external server?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related