SQL Vs NOSQL

Nadeem Akhtar — Wed, 04 Jun 2025 16:07:31 +0000

🧠 SQL vs NoSQL – What’s the Difference?

When we build websites or apps, we need a place to store data. That place is called a database.

There are two main types: SQL and NoSQL. Let’s understand both in simple words.

✅ What is SQL?

SQL stands for Structured Query Language.

It stores data in a table format – like an Excel sheet with rows and columns.

Main features:

Fixed structure – all data must follow the same format
Good for organized and clean data
You can run complex queries to get reports
It is vertically scalable (means: you can increase CPU or RAM of one server)

Examples: MySQL, PostgreSQL, Oracle

🧾 Example SQL Table:

item_id	item_name	category	price
1	Hamburger	American	299
2	French Fries	American	150
3	Pasta	Italian	250
4	Biryani	Indian	200

✅ What is NoSQL?

NoSQL means Not Only SQL.

It stores data in a flexible format – like JSON (key-value pairs).

Main features:

No fixed structure – every item can have different fields
Best for real-time, fast-changing data
It is horizontally scalable (means: data is spread across many servers)

Examples: MongoDB, Firebase, Cassandra

🧾 Example NoSQL Data:

{
  "userId": 1,
  "id": 1,
  "title": "Buy Groceries",
  "completed": false
}

🛒 Real-Life Examples

Flipkart – E-commerce Website Flipkart has many types of products: electronics, clothes, kitchen items. Each product needs different data fields:

Electronics: RAM, storage, processor

Clothing: size, fabric, color

Kitchen items: weight, material

SQL needs same format for all products, which is difficult here.
So, Flipkart uses NoSQL for product data.

Netflix – Streaming Platform Netflix uses both SQL and NoSQL:

✅ SQL for fixed data like movie title, release date

🔄 NoSQL for user recommendations (every user sees different content)

Uber – Ride Sharing App Uber data keeps changing in real-time (cab location, ride status). Also, they keep adding new features like Uber Pool, Share Ride.

So, Uber uses NoSQL – because it’s fast and flexible.

🧭 When to Use SQL vs NoSQL?
Use SQL when: Use NoSQL when:
✅ Your data is structured 🔄 Your data is unstructured or flexible
🧠 You need complex reports ⚡ You need speed and real-time updates
📊 Data format doesn’t change much 🌍 You want to scale across many servers

🎯 Conclusion
SQL is great for structured and clean data (like banking or employee records)

NoSQL is best for flexible, fast, and real-time apps (like e-commerce, streaming, ride-sharing)

Most big companies use both, based on the need.

💡 Know when to use what — and you’ll build faster, smarter apps!

Functions

Nadeem Akhtar — Wed, 28 May 2025 06:08:20 +0000

3 Ways to Create Functions in JavaScript
There are three ways to create functions in JavaScript:

1.Plain or Normal Function
2.Function Expression (function without a name stored in a variable)
3.Arrow Function (can be written in implicit or explicit style and can return objects)

Normal Function

function sayMyName() {   // `()` inside is called parameters
  console.log("Sam");
}

sayMyName;   // This is a reference to the function, but it does NOT run it
sayMyName(); // This calls the function and runs it

// Output: Sam

Function Expression This is a function without a name stored in a variable.

const showNum = function(a) {
  return a;
}

console.log(showNum(5)); // Output: 5
console.log(showNum());  // Output: undefined, because no argument was passed

Arrow Function Arrow functions can be written in two ways: a) Implicit Return (no need to write return keyword)

const addNum = (a, b) => a + b;
console.log(addNum(2, 3)); // Output: 5
console.log(addNum());      // Output: NaN (because no arguments passed)

You can also use parentheses for returning an object:

const addNumTwo = (a, b) => (a + b);
console.log(addNumTwo(3, 4)); // Output: 7

b) Explicit Return (use return keyword inside braces)

const addNumOne = (a, b) => {
  return a + b;
}

const result = addNumOne(2, 3);
console.log(result); // Output: 5

Arrow Function Returning Objects
You can use arrow functions to return objects like this:

const result = (str) => ({ length: str.length, uppercase: str.toUpperCase() });
console.log(result("hello")); 
// Output: { length: 5, uppercase: "HELLO" }

const analyzeSentence = sentence => ({ wordCount: sentence.split(" ").length });
console.log(analyzeSentence("JavaScript is fun"));
// Output: { wordCount: 3 }

const calculateSquareAndCube = (num) => ({ square: num ** 2, cube: num ** 3 });
console.log(calculateSquareAndCube(4));
// Output: { square: 16, cube: 64 }

More Arrow Function Examples (with explicit return)

Sum of Array Elements
const arr = [1, 2, 3, 4, 5];
const sumOfArr = (arr) => {
  let sum = 0;
  for (let i = 0; i < arr.length; i++) {
    sum += arr[i];
  }
  return sum;
}

console.log(sumOfArr(arr)); // Output: 15

Reverse a String

const reverse = (str) => {
  let rev = "";
  for (let i = str.length - 1; i >= 0; i--) {
    rev += str[i];
  }
  return rev;
}

console.log(reverse("hello")); // Output: olleh