How to connect to Heroku PostgresQL database from Express?

Question

I am trying to deploy a PERN app to Heroku. I created a Heroku Postgres database and deployed my React frontend - Node/Express backend app to Heroku.

How do I connect to the database from within my Express code? I have been using npm pg so far when the app was still local.

I can't seem to find any information about this on the internet...

silencedogood · Accepted Answer · 2021-07-27 18:08:10Z

1

You'll need to import a Pool from the postgre module, then set the connection string. It should look something like this:

const {Pool} = require('pg');

const connectStr = process.env.DATABASE_URL;
const pool = new Pool({
    connectionString: connectStr,
    ssl: true
});

Then you can query the database with something akin to this:

exports.dbAction = function(req, res) {

process.env.NODE_TLS_REJECT_UNAUTHORIZED = '0';

pool.query("select * from exampleTable", (err, 
results) => {
        if (err) {
            console.log(err);
            throw err;
        }
    res.json(results.rows);
    });
  
}

process.env.NODE_TLS_REJECT_UNAUTHORIZED = '0'; instructs Node to allow untrusted certificates (untrusted = not verified by a certificate authority). It's not a recommended setting in production mode. However, while in development, it's a handy workaround.

edited Jul 27, 2021 at 18:08

answered Jul 23, 2021 at 18:34

silencedogood

3,3291 gold badge16 silver badges38 bronze badges

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

2 Comments

Stijn Klijn Over a year ago

That worked! Thanks. Can you explain the line process.env.NODE_TLS_REJECT_UNAUTHORIZED = '0'; ?

silencedogood Over a year ago

@StijnKlijn Cool. And yeah this instructs Node to allow untrusted certificates (untrusted = not verified by a certificate authority). It's not a recommended setting in production mode. However, while in development, it's a handy workaround.

Collectives™ on Stack Overflow

How to connect to Heroku PostgresQL database from Express?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related