Tag feed

#dbms

350 posts118 followers

Explore Hashnode

Alternatives

Trending tags this week

DDivyanshujs-core.hashnode.devSep 17 · 6 min read

ACID Transactions in DBMS Explained (MongoDB)

If you're building out a full-stack application today maybe wiring up a Node.js backend or pulling server-side data in Next.js - you've probably had to make the database choice. For years, the convent

0

YJYasir Jafriyasir323.hashnode.devSep 14 · 12 min read

Choosing a Primary Key: A Tour of the IDs Real Systems Actually Use

The last article in this series was all about picking the right UUID version. This one pulls back a bit further, because UUIDs are just one item on a much longer menu, and depending on what you're bui

0

KSKanishka Shashinodej.hashnode.devJun 23 · 10 min read

Modern Database Access: Prisma, Drizzle, and ORMs Explained

Where Does Application Data Live After a User Closes the App? Imagine you're using an e-commerce application. You create an account, add products to your cart, place an order, and close the app. The n

0

OEOlasunkanmi Emmanuel Jesuferanmifreecodecamp.orgMar 25 · 16 min read

An Introduction to Database System Design

These days, businesses and startups rely on well-designed databases to manage vast amounts of data. In domains like Healthcare, E-commerce, and Fintech/Banking, a solid database design ensures data in

0

SSSaurabh Singh Rajputbasics-of-sql.hashnode.devFeb 18 · 4 min read

🚀 The Ultimate Sql Master Guide

1️⃣ What is SQL? (Foundation Strong Karo) SQL = Structured Query Language Used for: Storing data Retrieving data Managing data Controlling access Handling transactions SQL works with Relational Databases 2️⃣ How Relational Database Actually L...

0

TKTushar Kapiltushar-dev.hashnode.devFeb 18 · 4 min read

🧯 PostgreSQL Production Incident: Understanding a Disk I/O Meltdown After a Holiday Backlog

This article documents a real-world PostgreSQL production incident.All business names, schemas, queries, IPs, and identifiers have been anonymized for confidentiality. 📌 System Overview OS: Ubuntu Server 24.04 LTS Database: PostgreSQL 16.x CPU:...

0

HRHammad Rizvihammad-csd.hashnode.devFeb 6 · 4 min read

🗄️ DBMS Unit 2: The Math, The Magic & The Clean-Up (Relational Algebra & Normalization)

Hello Friends! 👋 Welcome back! After understanding the basic architecture in Unit 1, today we dived into the Logic behind databases. Unit 2 is all about "How to talk to the Database" (Relational Algebra & SQL) and "How to keep the Database clean" (N...

0

NNikhithabugfreenik.hashnode.devFeb 4 · 3 min read

🚀 What is SPOF (Single Point of Failure)?

In system design, SPOF means: When one part of the system fails and the whole system stops working. In short: One problem → Entire app is down Good companies always try to remove SPOF so users don’t face downtime. 💻 Example: One Developer Doing Al...

0

AHAwadhe Hossainuiudbms.hashnode.devFeb 1 · 1 min read