How do I use Sequelize with Node.js?

How do I use Sequelize with Node.js?

Sequelize is a promise-based ORM for Node.js. You can start by installing it using npm: npm install sequelize.

What database systems does Sequelize support?

Sequelize supports various databases like MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

Can you show me a simple example of defining a model?

Sure! Here's a basic example:

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:');

const User = sequelize.define('User', {
  username: {
    type: DataTypes.STRING,
    allowNull: false
  },
  birthday: {
    type: DataTypes.DATE
  }
});

How do I perform CRUD operations with Sequelize?

You can use methods like create(), findAll(), update(), and destroy() to perform CRUD operations. For example:

// Create a new user
await User.create({ username: 'john_doe', birthday: new Date(1990, 1, 1) });