DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
⚠️ The SQL Query That Nearly Crashed Our Production Server

⚠️ The SQL Query That Nearly Crashed Our Production Server

32
Comments 24
3 min read
NORMALIZATION

NORMALIZATION

Comments
2 min read
How to Deploy a PostgreSQL Database on AWS RDS (Step-by-Step)

How to Deploy a PostgreSQL Database on AWS RDS (Step-by-Step)

Comments
7 min read
Acid Properties with SQL Transactions

Acid Properties with SQL Transactions

Comments
2 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

Comments
2 min read
🚀 Day 35 of My Data Journey

🚀 Day 35 of My Data Journey

1
Comments
1 min read
Understanding 1NF, 2NF, and 3NF Using SQL — Step-by-Step Implementation

Understanding 1NF, 2NF, and 3NF Using SQL — Step-by-Step Implementation

Comments
3 min read
Indexing, Hashing & Query Optimization IN DBMS

Indexing, Hashing & Query Optimization IN DBMS

Comments
2 min read
🔥ACID Properties with SQL Transactions

🔥ACID Properties with SQL Transactions

Comments
2 min read
Transactions, Deadlocks & Log-Based Recovery in MySQL

Transactions, Deadlocks & Log-Based Recovery in MySQL

Comments
2 min read
🚀 Indexing, Hashing & Query Optimization in SQL (with Examples)

🚀 Indexing, Hashing & Query Optimization in SQL (with Examples)

Comments
2 min read
Supabase Managing database migrations across multiple environments (Local, Staging, Production)

Supabase Managing database migrations across multiple environments (Local, Staging, Production)

1
Comments
26 min read
How Database Indexes Improve SQL Performance — and When Not to Use Them

How Database Indexes Improve SQL Performance — and When Not to Use Them

1
Comments
2 min read
A Beginner’s Guide to AWS DynamoDB: Creating Your First Table

A Beginner’s Guide to AWS DynamoDB: Creating Your First Table

1
Comments
4 min read
WinForms in 2025? Here's the Slick MSSQL Monitoring App I Built

WinForms in 2025? Here's the Slick MSSQL Monitoring App I Built

1
Comments 1
1 min read
THE BACKBONE OF DATABASE REALIABILITY: EXPLORING ACID IN ACTION WITH SQL TRANSACTION A STEP-STEP-STEP GUIDE

THE BACKBONE OF DATABASE REALIABILITY: EXPLORING ACID IN ACTION WITH SQL TRANSACTION A STEP-STEP-STEP GUIDE

1
Comments
2 min read
Normalization in DBMS with SQL Examples (1NF 2NF 3NF)

Normalization in DBMS with SQL Examples (1NF 2NF 3NF)

1
Comments
2 min read
Real-Time Crypto Data Pipeline

Real-Time Crypto Data Pipeline

3
Comments
3 min read
DBMS-Transaction, Deadlocks & Log-Based Recovery

DBMS-Transaction, Deadlocks & Log-Based Recovery

Comments
1 min read
Building the Enterprise DAL: Database Structure and ULIDs

Building the Enterprise DAL: Database Structure and ULIDs

1
Comments
2 min read
Database Normalization in Livesql

Database Normalization in Livesql

Comments
2 min read
🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster)

🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster)

2
Comments
3 min read
ACID PROPERTY IN DBMS

ACID PROPERTY IN DBMS

Comments
2 min read
"Indexing, Hashing & Query Optimization with MySQL — Students Table Example"

"Indexing, Hashing & Query Optimization with MySQL — Students Table Example"

Comments
3 min read
Database-per-tenant {Explicando Padrões de arquitetura de banco de dados multilocatários}

Database-per-tenant {Explicando Padrões de arquitetura de banco de dados multilocatários}

Comments
3 min read
loading...