How do I connect a Node.js app to a Heroku database?

How do I connect a Node.js app to a Heroku database?

To connect your Node.js app to a Heroku database, you first need to provision a database on Heroku. You can do this using the Heroku CLI with the command heroku addons:create heroku-postgresql:hobby-dev.

What do I do after provisioning the database?

After provisioning, you can access the database URL from your Heroku dashboard or by running heroku config. Use this URL to connect your app using a library like pg for PostgreSQL.

Can you show me an example of how to use the database URL in my code?

Sure! Here's a simple example:

const { Client } = require('pg');
const client = new Client({
  connectionString: process.env.DATABASE_URL,
  ssl: { rejectUnauthorized: false }
});

client.connect();