Sequelize ORM setup in Express - Mini Project: Build & Apply

Sequelize ORM setup

📖 Scenario: You are building a simple Express app that needs to store user data in a database. To manage the database easily, you will set up Sequelize ORM.

🎯 Goal: Set up Sequelize ORM in your Express app by creating a Sequelize instance, configuring the database connection, defining a User model, and syncing the model with the database.

📋 What You'll Learn

Create a Sequelize instance connected to a SQLite database file named database.sqlite

Define a User model with username (string) and email (string) fields

Sync the User model with the database

Export the User model for use in other parts of the app

💡 Why This Matters

🌍 Real World

Sequelize ORM helps developers manage database operations easily without writing raw SQL. It is widely used in Node.js backend applications.

💼 Career

Knowing how to set up and use Sequelize is valuable for backend developer roles working with Node.js and relational databases.

1

Create Sequelize instance

Create a constant called Sequelize by requiring the sequelize package. Then create a constant called sequelize by instantiating Sequelize with a SQLite database file named database.sqlite using the dialect option set to 'sqlite' and storage option set to 'database.sqlite'.

Express

# Your code here

Need a hint?

Use require('sequelize') to get Sequelize. Then create a new Sequelize instance with the correct options for SQLite.

2

Define User model

Define a constant called User by calling sequelize.define with the model name 'User' and an object describing two fields: username and email, both of type Sequelize.STRING.

Express

const { Sequelize } = require('sequelize');

const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: 'database.sqlite'
});

// Define User model here
# Your code here

Need a hint?

Use sequelize.define('User', { username: Sequelize.STRING, email: Sequelize.STRING }) to create the model.

3

Sync User model with database

Call sequelize.sync() to sync all defined models with the database.

Express

const { Sequelize } = require('sequelize');

const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: 'database.sqlite'
});

const User = sequelize.define('User', {
  username: Sequelize.STRING,
  email: Sequelize.STRING
});

// Sync models with database
# Your code here

Need a hint?

Call sequelize.sync() to create tables if they don't exist.

4

Export User model

Export the User model using module.exports = User.

Express

const { Sequelize } = require('sequelize');

const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: 'database.sqlite'
});

const User = sequelize.define('User', {
  username: Sequelize.STRING,
  email: Sequelize.STRING
});

sequelize.sync();

// Export User model
# Your code here

Need a hint?

Use module.exports = User to export the model.