Skip to main content

Node.js

This guide will walk you through the process of connecting to your Rapidapp PostgreSQL database using Node.js. By the end of this tutorial, you'll be able to establish a connection to your database and start interacting with your data programmatically.

Prerequisites​

Before you begin, ensure that you have the following:

  • Node.js installed on your system. You can download it from the official Node.js website
  • A code editor or IDE like Visual Studio Code, WebStorm, or Sublime Text.
  • PostgreSQL database credentials from Rapidapp:
    • Hostname
    • Port
    • Database
    • Username
    • Password

Step 1: Set Up Your Node.js Project​

  • Create a new directory for your project and navigate into it:
mkdir rapidapp-postgres-connection
cd rapidapp-postgres-connection
  • Initialize a new Node.js project:
npm init -y
  • Install the pg package for PostgreSQL:
npm install pg

Step 2: Write Node.js Code to Connect to PostgreSQL​

Create a new file, index.js, and add the following code:

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

// Replace these with your actual RapidApp PostgreSQL credentials
const client = new Client({
    host: 'your-rapidapp-hostname',
    port: 5432,  // Default PostgreSQL port
    user: 'your-username',
    password: 'your-password',
    database: 'your-database',
    ssl: {
        rejectUnauthorized: false
    }
});

client.connect()
    .then(() => console.log('Successfully connected to RapidApp PostgreSQL database!'))
    .catch(err => console.error('Failed to connect to the database:', err.stack))
    .finally(() => client.end());

Step 3: Replace Placeholder Values​

Replace the placeholder values in the host, port, user, password, and database fields with your actual Rapidapp PostgreSQL database credentials:

  • host: The hostname of your PostgreSQL server.
  • port: The port number (default is 5432).
  • user: Your database username.
  • password: Your database password.
  • database: The name of your database. Example:
const client = new Client({
    host: 'pg.rapidapp.io',
    port: 5432,
    user: 'myusername',
    password: 'mypassword',
    database: 'mydatabase',
    ssl: {
        rejectUnauthorized: false
    }
});

Step 4: Run Your Application​

  • Run your Node.js application:
node index.js
  • If everything is set up correctly, you should see the message:
Successfully connected to RapidApp PostgreSQL database!

If there’s an issue, an error message will be printed to help you diagnose the problem.

Conclusion​

Congratulations! You’ve successfully connected to your Rapidapp PostgreSQL database using Node.js. Now, you're ready to start executing SQL queries, performing CRUD operations, and integrating your Node.js application with the database.

For more advanced usage and examples, refer to the pg documentation or the Rapidapp Blog.

Happy coding! 🚀