How can I use an ORM with Node.js and PostgreSQL?

How can I use an ORM with Node.js and PostgreSQL?

You can use an ORM like Sequelize or TypeORM to interact with PostgreSQL in Node.js. Would you like a code example?

Yes, please provide a simple example using Sequelize.

Sure! First, install Sequelize and pg: npm install sequelize pg. Then, you can set it up like this:

const { Sequelize } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'postgres',
});

// Test the connection
sequelize.authenticate().then(() => {
  console.log('Connection has been established successfully.');
}).catch(err => {
  console.error('Unable to connect to the database:', err);
});

What about defining models and performing CRUD operations?

You can define models using sequelize.define. For example:

const User = sequelize.define('User', {
  username: {
    type: Sequelize.STRING,
    allowNull: false,
  },
  password: {
    type: Sequelize.STRING,
    allowNull: false,
  },
});

// Create a new user
User.create({ username: 'john', password: 'doe' });