PostgreSQL: Using PostgreSQL with Node.js/TypeORM

This documentation is part of the Getting started guide. You can view the complete guide here: How to get started with PostgreSQL.

👋 Welcome to the Stackhero documentation!

Stackhero offers a fully managed PostgreSQL cloud solution, designed for reliability and performance:

• Unlimited connections and data transfers for effortless scalability.
• PgAdmin web interface included for straightforward database management.
• A wide range of popular extensions included, such as PostGIS, TimescaleDB, and PgVector.
• Simple, one-click updates to keep your database secure and up to date.
• Optimal performance and enhanced security on private, dedicated infrastructure.

Save time and make your life easier: it takes just 5 minutes to try Stackhero's PostgreSQL cloud hosting solution!

To connect to PostgreSQL from Node.js using TypeORM, set the ssl flag to true as shown in the example below:

createConnection({
  type: 'postgres',
  host: '<XXXXXX>.stackhero-network.com',
  port: <PORT>,
  username: '<USERNAME>',
  password: '<PASSWORD>',
  database: '<DATABASE>',
  extra: {
    ssl: true
  }
});