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.
What is Geo-Redundancy? A Comprehensive Guide

What is Geo-Redundancy? A Comprehensive Guide

Comments
3 min read
Cracking MySQL Performance: What is Indexing and Why It Matters

Cracking MySQL Performance: What is Indexing and Why It Matters

2
Comments
2 min read
AI-Driven Development: My Database Experiment

AI-Driven Development: My Database Experiment

Comments
4 min read
Database Sharding 101

Database Sharding 101

5
Comments 3
5 min read
Collation in Database - What you need to know

Collation in Database - What you need to know

Comments
3 min read
How to simplify the Merge Operations Across Tables from Multiple Databases

How to simplify the Merge Operations Across Tables from Multiple Databases

6
Comments
6 min read
Understanding Complex Database Concepts: An In-Depth Guide

Understanding Complex Database Concepts: An In-Depth Guide

1
Comments
25 min read
How to Design a Write-Heavy System: A Beginner-Friendly Guide You’ll Want to Bookmark

How to Design a Write-Heavy System: A Beginner-Friendly Guide You’ll Want to Bookmark

8
Comments 1
3 min read
Export database tables to Excel with one click

Export database tables to Excel with one click

1
Comments
2 min read
SQL: The Secret Weapon Behind Data Analytics and Data Science

SQL: The Secret Weapon Behind Data Analytics and Data Science

4
Comments 3
4 min read
Goodbye Bastion, Hello Zero-Trust: Our Journey to Simplified RDS Access

Goodbye Bastion, Hello Zero-Trust: Our Journey to Simplified RDS Access

Comments
18 min read
What Is a Single View?

What Is a Single View?

Comments
2 min read
Implementing Role-Based Access Control (RBAC) in MySQL

Implementing Role-Based Access Control (RBAC) in MySQL

4
Comments 2
3 min read
What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

8
Comments
9 min read
AZURE CLI (MANAGING AZURE RESOURCES)

AZURE CLI (MANAGING AZURE RESOURCES)

2
Comments
2 min read
RisingWave Turns Four: Our Journey Beyond Democratizing Stream Processing

RisingWave Turns Four: Our Journey Beyond Democratizing Stream Processing

Comments
9 min read
Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.

Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.

Comments
16 min read
Conditional Grouping — From SQL to SPL #37

Conditional Grouping — From SQL to SPL #37

6
Comments 4
2 min read
Best 7 Logical Database Design Tools in 2025

Best 7 Logical Database Design Tools in 2025

10
Comments 2
5 min read
What is Synthetic Data?

What is Synthetic Data?

Comments
1 min read
How to Implement Serializable Snapshot Isolation for Transactions

How to Implement Serializable Snapshot Isolation for Transactions

6
Comments
12 min read
Dependency Injections Made Easy: How They Work

Dependency Injections Made Easy: How They Work

8
Comments
5 min read
Understanding MongoDB Text Search: Handling Special Characters and Pitfalls

Understanding MongoDB Text Search: Handling Special Characters and Pitfalls

6
Comments
3 min read
All Data and AI Weekly #187 - April 28, 2025

All Data and AI Weekly #187 - April 28, 2025

5
Comments
3 min read
PostgreSQL aborts the transactions on error

PostgreSQL aborts the transactions on error

1
Comments
3 min read
loading...