Creating a database & mongodb

MongoDB Setup and Connection Guide

This guide walks you through the steps to create a MongoDB Atlas cluster, set up a user, retrieve the connection string, and connect the database using MongoDB Compass.

1. Creating a MongoDB Atlas Account and Setting up a Cluster

Step 1: Go to MongoDB Website

1. Visit the MongoDB Atlas website.
2. Sign up or log in if you already have an account.

Step 2: Create a Free M0 Cluster

1. After signing in, go to the Atlas dashboard.
2. Click on the Create a New Cluster button.
3. Choose a free tier by selecting the M0 Sandbox cluster.
4. Choose a cloud provider (AWS, Google Cloud, or Azure) and a region (select a region close to your location for optimal performance).
5. Click Create Cluster.

This process may take a few minutes. MongoDB will notify you once the cluster is ready.

2. Creating a Database User

Step 3: Set Up a Database User

1. After the cluster is created, you will need to set up a user to access the database.
2. Navigate to the Database Access tab on the left side of the Atlas dashboard.
3. Click Add New Database User.
4. Enter a username and password for the new user. Keep these credentials secure, as you will need them to connect to the database.
5. Choose Read and write to any database as the role.
6. Click Add User.

3. Setting Network Access

Step 4: Configure Network Access

1. Navigate to the Network Access tab.
2. Click Add IP Address.
3. Select Allow access from anywhere if you want to access your database from any IP address, or add your specific IP address.
4. Click Confirm.

4. Getting the Connection String

Step 5: Retrieve the Connection String

1. Go to the Clusters tab on the left side.
2. Click on Connect next to your cluster.
3. Choose Connect your application.
4. Copy the connection string that looks something like this:
   Copy

   mongodb+srv://<username>:<password>@cluster0.mongodb.net/<dbname>?retryWrites=true&w=majority
   

• Replace <username> and <password> with the credentials of the user you created.
• Replace <dbname> with the name of the database you want to connect to.

5. Installing and Connecting MongoDB Compass

Step 6: Install MongoDB Compass

1. Download and install MongoDB Compass.
2. Once installed, open MongoDB Compass.

Step 7: Connect to Your Cluster

1. In MongoDB Compass, you will be prompted to enter the connection string.
2. Paste the connection string you copied earlier from MongoDB Atlas.
3. Replace <password> with the password of the user you created.
4. Click Connect.

You should now be successfully connected to your MongoDB cluster and able to manage your database locally using MongoDB Compass.

6. Verifying Connection

Step 8: Check Connection in MongoDB Compass

1. Once connected, MongoDB Compass will show a list of your databases in the cluster.
2. Click on your database to manage collections, documents, and perform queries.
3. You can create new databases or collections using the New Database button.

7. Creating and Managing Databases (Optional)

Step 9: Create a New Database

1. After connecting, click on the Databases tab in MongoDB Compass.
2. Click Create Database.
3. Enter a Database Name and Collection Name for your new collection (table).
4. Click Create Database to create a new database and collection in your MongoDB cluster.

Step 10: Managing Collections

1. Once inside a database, you can add, delete, or update documents (records) inside a collection.
2. To add a document, click Insert Document.
3. Add your data in JSON format and click Insert.

8. Troubleshooting

Step 11: Handling Connection Issues

• Whitelist IP Address: Ensure that your current IP address is whitelisted in Network Access settings in MongoDB Atlas.
• User Authentication: Make sure the correct username and password are used in the connection string.
• Connection Timeout: Check your internet connection or cluster region if the connection is timing out.

Step 12: Resetting MongoDB Compass Configuration (if needed)

1. If you face persistent connection issues, try resetting MongoDB Compass settings.
2. Go to Settings → Reset Compass to return to the default configuration.

Conclusion

By following this guide, you have successfully:

• Installed MongoDB Compass.
• Connected it to your MongoDB Atlas cluster.
• Verified the connection and managed databases.
• Handled basic troubleshooting issues.

Now, you are ready to start working with MongoDB locally or integrate it into your applications.

Database Connection and MongoDB CRUD Operations Overview

This document covers how to connect to a MongoDB server and perform CRUD (Create, Read, Update, Delete) operations using the MongoDB Node.js library.

1. Connecting to the Database Server

To connect to a MongoDB, first install the MongoDB Node.js driver:

npm install mongodb
<div data-shiki><pre class="shiki github-light" style="background-color:#fff;color:#24292e" tabindex="0"><code><span class="line"><span></span></span>
<span class="line"><span>Database Connection</span></span></code></pre></div>
const { MongoClient } = require('mongodb');
// Connection URL
const url = 'mongodb://localhost:27017';
const client = new MongoClient(url);

// Database Name
const dbName = 'Namaste-Nodejs';

async function main() {
 await client.connect();
 console.log('Connected successfully to server');
 const db = client.db(dbName);
 const collection = db.collection('User');

 return 'done.';
}
main()
 .then(console.log)
 .catch(console.error)
 .finally(() => client.close());
<div data-shiki><pre class="shiki github-light" style="background-color:#fff;color:#24292e" tabindex="0"><code><span class="line"><span></span></span>
<span class="line"><span>## 2. Introduction to CRUD</span></span>
<span class="line"><span></span></span>
<span class="line"><span>CRUD operations are fundamental to interacting with databases. Each operation corresponds to a specific action that can be performed on data stored in the database. Here’s a brief overview of each operation:</span></span>
<span class="line"><span></span></span>
<span class="line"><span>### 1.1 Create</span></span>
<span class="line"><span></span></span>
<span class="line"><span>- **Definition**: The Create operation adds new documents to a MongoDB collection.</span></span>
<span class="line"><span>- **Purpose**: Used to insert new records or entries into a database.</span></span>
<span class="line"><span>- **Example Use Cases**: Adding a new user profile, creating a new product listing, or recording a new transaction.</span></span></code></pre></div>
const  data  = {
firstname:  "Akshad",
lastname:  "Jaiswal",
city:  "Pune",
phoneNumber:  "88526587",
}
//Create
const insertData = await collection.insertMany([data])
console.log("data inserted = ", insertData)
<div data-shiki><pre class="shiki github-light" style="background-color:#fff;color:#24292e" tabindex="0"><code><span class="line"><span></span></span>
<span class="line"><span>### 1.2 Read</span></span>
<span class="line"><span></span></span>
<span class="line"><span>- **Definition**: The Read operation retrieves documents from a MongoDB collection.</span></span>
<span class="line"><span>- **Purpose**: Used to query and obtain data stored in the database.</span></span>
<span class="line"><span>- **Example Use Cases**: Fetching user details, listing products, or generating reports based on stored data.</span></span></code></pre></div>
//Read
const  findData  =  await  collection.find({}).toArray();
console.log("All data :", findData)
<div data-shiki><pre class="shiki github-light" style="background-color:#fff;color:#24292e" tabindex="0"><code><span class="line"><span></span></span>
<span class="line"><span>### 1.3 Update</span></span>
<span class="line"><span></span></span>
<span class="line"><span>- **Definition**: The Update operation modifies existing documents in a MongoDB collection.</span></span>
<span class="line"><span>- **Purpose**: Used to change the values of specific fields in existing documents.</span></span>
<span class="line"><span>- **Example Use Cases**: Updating user information (like email or password), changing the status of an order, or modifying product details.</span></span></code></pre></div>
// Update
const updateData = await collection.updateOne({ _id: new ObjectId('67066d6a3be8f41630d5dae4') }, { $set: { firstname: "Mint" } })
console.log("Updated document ", updateData)
<div data-shiki><pre class="shiki github-light" style="background-color:#fff;color:#24292e" tabindex="0"><code><span class="line"><span></span></span>
<span class="line"><span>### 1.4 Delete</span></span>
<span class="line"><span></span></span>
<span class="line"><span>- **Definition**: The Delete operation removes documents from a MongoDB collection.</span></span>
<span class="line"><span>- **Purpose**: Used to permanently delete records that are no longer needed.</span></span>
<span class="line"><span>- **Example Use Cases**: Deleting a user account, removing a product that is out of stock, or purging outdated transaction records.</span></span></code></pre></div>
//delete
const deletedata = await collection.deleteOne({ _id: new ObjectId('670668562c6bd11e25050c13') })
console.log("deleted data=>", deletedata)

3. Summary of CRUD Operations

4. Conclusion

Understanding CRUD operations is essential for effectively managing data in a MongoDB database. These operations enable users to create, retrieve, modify, and delete records, allowing for comprehensive data manipulation and management. Mastery of these operations forms the foundation for building applications that rely on database interactions.