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.
How to Optimize a Slow Query

How to Optimize a Slow Query

Comments
2 min read
Understanding Atomicity: The First Pillar of ACID Transactions

Understanding Atomicity: The First Pillar of ACID Transactions

5
Comments
5 min read
Duplicate Rows Detection in MySQL

Duplicate Rows Detection in MySQL

5
Comments
4 min read
Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure

Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure

1
Comments
2 min read
How MySQL Handles a Single Data Insert

How MySQL Handles a Single Data Insert

11
Comments
6 min read
Optimized Email lookup for millions of users

Optimized Email lookup for millions of users

1
Comments 2
3 min read
🔍 Understanding Clustered vs Non-Clustered Indexes in SQL Server

🔍 Understanding Clustered vs Non-Clustered Indexes in SQL Server

6
Comments
3 min read
Normalization: How to Structure Your Database for Efficiency

Normalization: How to Structure Your Database for Efficiency

4
Comments
2 min read
Master SQL with These Handy Tools, Tips, and Tricks

Master SQL with These Handy Tools, Tips, and Tricks

1
Comments
3 min read
LINQ in Entity Framework You Should Know 🧐

LINQ in Entity Framework You Should Know 🧐

Comments
2 min read
7 Best Change Data Capture (CDC) Tools in 2025

7 Best Change Data Capture (CDC) Tools in 2025

4
Comments
6 min read
The simplest way to count 100 billion unique IDs: Part 1

The simplest way to count 100 billion unique IDs: Part 1

2
Comments 1
5 min read
GraphQL in 2025: What It Is, Why It Matters, and Whether You Should Bother Learning It

GraphQL in 2025: What It Is, Why It Matters, and Whether You Should Bother Learning It

2
Comments 2
3 min read
I made a project in Golang with no packages or libraries (also not ORM's)

I made a project in Golang with no packages or libraries (also not ORM's)

Comments
8 min read
The simplest way to count 100 billion unique IDs: Part 2

The simplest way to count 100 billion unique IDs: Part 2

2
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.