Node.js — Database

Database Options

Database	Package	Type
MySQL	mysql2	SQL
PostgreSQL	pg	SQL
MongoDB	mongoose	NoSQL
SQLite	sqlite3	SQL

MySQL Connection

const mysql = require('mysql2/promise');

async function connect() {
    const connection = await mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: 'password',
        database: 'mydb'
    });
    
    const [rows] = await connection.execute('SELECT * FROM users');
    console.log(rows);
    
    await connection.end();
}

PostgreSQL Connection

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

const client = new Client({
    host: 'localhost',
    user: 'postgres',
    password: 'password',
    database: 'mydb'
});

await client.connect();
const res = await client.query('SELECT * FROM users');
console.log(res.rows);
await client.end();

MongoDB Connection

const mongoose = require('mongoose');

mongoose.connect('mongodb://localhost/mydb');

const userSchema = new mongoose.Schema({
    name: String,
    email: String
});

const User = mongoose.model('User', userSchema);

Mini Practice

1. Connect to MySQL
2. Connect to PostgreSQL
3. Connect to MongoDB
4. Perform basic CRUD operations

Up Next

Continue with MySQL — MySQL integration.