What experience do you have working with projects using PostgreSQL?

In projects with PostgreSQL, I have worked on database setup and optimization, writing SQL queries, and using ORM (such as Sequelize or TypeORM) for interaction with the database from Node.js.

My main experience includes:

• Designing database schemas with normalization.
• Writing complex queries with JOINs, aggregations, and indexes to improve performance.
• Using transactions to ensure data integrity.
• Configuring connection pooling for efficient resource utilization.

An example of connecting to PostgreSQL using the pg library in Node.js:

const { Pool } = require('pg');
const pool = new Pool({
  user: 'user',
  host: 'localhost',
  database: 'mydb',
  password: 'password',
  port: 5432,
});

async function getUsers() {
  const res = await pool.query('SELECT * FROM users');
  return res.rows;
}

This experience allows for effective work with PostgreSQL in backend projects on Node.js.