Why database connectivity matters in Node.js - See It in Action

Why database connectivity matters

📖 Scenario: You are building a simple Node.js app that needs to store and retrieve user information. To do this, you must connect your app to a database. This project will help you understand why connecting to a database is important and how to set up that connection.

🎯 Goal: Create a Node.js script that connects to a database, sets up a configuration for the connection, performs a simple query to fetch data, and closes the connection properly.

📋 What You'll Learn

Create a database connection object with exact parameters

Add a configuration variable for connection timeout

Write a function to query the database for all users

Close the database connection after the query

💡 Why This Matters

🌍 Real World

Connecting to a database is essential for apps that store and retrieve data like user profiles, orders, or messages.

💼 Career

Understanding database connectivity is a key skill for backend developers and full-stack engineers working with Node.js.

1

Create the database connection object

Create a constant called dbConfig that is an object with these exact properties: host set to 'localhost', user set to 'admin', password set to 'secret', and database set to 'usersdb'.

Node.js

// Create the dbConfig object with host, user, password, and database
// Your code here

Need a hint?

Think of dbConfig as the address and keys to your database house.

2

Add a connection timeout configuration

Add a constant called connectionTimeout and set it to 5000 (milliseconds).

Node.js

const dbConfig = {
  host: 'localhost',
  user: 'admin',
  password: 'secret',
  database: 'usersdb'
};

// Add connectionTimeout constant set to 5000
// Your code here

Need a hint?

This timeout helps your app stop trying to connect if the database is not responding quickly.

3

Write a function to query all users

Write an async function called fetchAllUsers that takes a connection parameter and returns the result of connection.query('SELECT * FROM users').

Node.js

const dbConfig = {
  host: 'localhost',
  user: 'admin',
  password: 'secret',
  database: 'usersdb'
};

const connectionTimeout = 5000;

// Write async function fetchAllUsers(connection) that returns connection.query('SELECT * FROM users')
// Your code here

Need a hint?

This function asks the database to give you all the user records.

4

Close the database connection

Add a line to close the database connection by calling connection.end() inside an async function called closeConnection that takes connection as a parameter.

Node.js

const dbConfig = {
  host: 'localhost',
  user: 'admin',
  password: 'secret',
  database: 'usersdb'
};

const connectionTimeout = 5000;

async function fetchAllUsers(connection) {
  return connection.query('SELECT * FROM users');
}

// Write async function closeConnection(connection) that calls connection.end()
// Your code here

Need a hint?

Closing the connection is like locking the door after you leave the database house.