What is your practical experience with databases?

In my experience working with databases in Node.js, I have used various approaches:

• Connecting to relational databases (e.g., PostgreSQL, MySQL) using libraries like pg, mysql2.
• Using ORMs such as Sequelize or TypeORM for convenient interaction with the database through objects.
• Working with NoSQL databases, such as MongoDB, via the Mongoose library.

Example of a simple query to PostgreSQL using pg:

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

async function getAllUsers() {
  const client = new Client({ connectionString: process.env.DATABASE_URL });
  await client.connect();
  const res = await client.query('SELECT * FROM users');
  await client.end();
  return res.rows;
}

I also have experience optimizing queries, writing migrations, and configuring connections.