How can I connect to different databases in Node.js?

How can I connect to different databases in Node.js?

You can connect to various databases in Node.js using different libraries. For example, you can use mongoose for MongoDB, pg for PostgreSQL, and mysql for MySQL.

Can you show me an example of connecting to MongoDB?

Sure! First, install mongoose using npm install mongoose. Then, you can connect 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('Connection error', err));

What about connecting to PostgreSQL?

For PostgreSQL, you can use the pg library. First, install it with npm install pg. Here's a simple example:

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

const client = new Client({
  user: 'yourusername',
  host: 'localhost',
  database: 'mydatabase',
  password: 'yourpassword',
  port: 5432,
});

client.connect()
  .then(() => console.log('PostgreSQL connected!'))
  .catch(err => console.error('Connection error', err));