How can I integrate a database with Express?

How can I integrate a database with Express?

You can integrate a database with Express by using an ORM like Sequelize or Mongoose for MongoDB. Would you like a code example?

Yes, please provide a code example using MongoDB.

Sure! First, install Mongoose with npm install mongoose. Then, you can connect to your database like this:

const mongoose = require('mongoose');

mongoose.connect('mongodb://localhost:27017/mydatabase', { useNewUrlParser: true, useUnifiedTopology: true })
  .then(() => console.log('MongoDB connected!'))
  .catch(err => console.error('MongoDB connection error:', err));

What about using PostgreSQL instead?

For PostgreSQL, you can use Sequelize. First, install it with npm install sequelize pg pg-hstore. Then, set it up like this:

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

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

sequelize.authenticate()
  .then(() => console.log('PostgreSQL connected!'))
  .catch(err => console.error('PostgreSQL connection error:', err));