How do you assess your skills in working with PostgreSQL database?

The assessment of PostgreSQL skills depends on experience and the tasks you have handled. For example:

• Familiar with SQL basics: creating tables, SELECT, INSERT, UPDATE, DELETE queries.
• Able to work with indexes, understanding their impact on performance.
• Used transactions and isolation levels to ensure data integrity.
• Wrote complex queries with JOINs, subqueries, window functions.
• Configured and optimized query performance using EXPLAIN.
• Worked with PostgreSQL extensions, such as PostGIS or pg_trgm.
• Used backup and restore tools.

Regarding Node.js, experience may include using ORM (e.g., Sequelize, TypeORM) or the pg driver for database interaction.

Example of connection using pg:

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

client.connect();

client.query('SELECT NOW()', (err, res) => {
  console.log(err, res.rows);
  client.end();
});