---
title: "Discussion on \"Database Design Fundamentals: Data Modeling, SQL vs. NoSQL, and Indexing\" | Hashnode"
description: "Discussion on \"Database Design Fundamentals: Data Modeling, SQL vs. NoSQL, and Indexing\". Every application generates data. Whether users create accounts, upload photos, like posts, or leave comments, we need a reliable way to store and retrieve that information.\n\nBut before choosing a database such as PostgreSQL or MongoDB, we need to understand what data our application stores and how users interact with it.\n\nThis process is called data modeling. It involves identifying the information we need, organizing it into logical entities, and defining the relationships between them.\n\nLet's explore how to design this database layer using a photo-sharing application as our example."
url: "https://hashnode.com/posts/database-design-fundamentals-data-modeling-sql-vs-nosql-and-indexing/6af8d64cf97ae75f9add09b7"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Database Design Fundamentals: Data Modeling, SQL vs. NoSQL, and Indexing](https://saipraneethbhattu.hashnode.dev/database-design-fundamentals-data-modeling-sql-vs-nosql-and-indexing?utm_source=hashnode&utm_medium=feed)

Every application generates data. Whether users create accounts, upload photos, like posts, or leave comments, we need a reliable way to store and retrieve that information. But before choosing a database such as PostgreSQL or MongoDB, we need to understand what data our application stores and how users interact with it. This process is called data modeling. It involves identifying the information we need, organizing it into logical entities, and defining the relationships between them. Let's explore how to design this database layer using a photo-sharing application as our example.

1d ago · 7 min read · saipraneethbhattu.hashnode.dev  
Read the article

-   [#system-design](https://hashnode.com/tag/system-design)
-   [#databases](https://hashnode.com/tag/databases)
-   [#sq](https://hashnode.com/tag/sq)
-   [#nosqldatabase](https://hashnode.com/tag/nosqldatabase)

## Written by

[SAI PRANEETH BHATTU](https://hashnode.com/@saipraneethbhattu)

@saipraneethbhattu · Detroit, Michigan

  
[View profile](https://hashnode.com/@saipraneethbhattu)

DevOps & Cloud Enthusiast

Passionate about Cloud and DevOps engineering. I write structured technical notes and beginner-friendly articles on AWS, Linux, CI/CD, networking, system architecture and modern software delivery workflows.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
