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.
Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

Comments
4 min read
Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

Comments
4 min read
Entenda Teorema CAP

Entenda Teorema CAP

1
Comments
5 min read
Understanding Query Cost in SQL

Understanding Query Cost in SQL

3
Comments 1
7 min read
Understanding T-SQL vs PL/SQL Database Curveballs

Understanding T-SQL vs PL/SQL Database Curveballs

1
Comments
3 min read
Beginner’s Guide to Designing a Relational Database Schema

Beginner’s Guide to Designing a Relational Database Schema

13
Comments 5
4 min read
Best MySQL Database Design Tools in 2025

Best MySQL Database Design Tools in 2025

11
Comments 2
8 min read
The Scaling Gauntlet: The Art of Query Archaeology

The Scaling Gauntlet: The Art of Query Archaeology

Comments 1
5 min read
How Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

4
Comments 2
3 min read
Oracle AI Database 26ai: Utilizing Memoptimized Rowstore Without Setting a Hint

Oracle AI Database 26ai: Utilizing Memoptimized Rowstore Without Setting a Hint

Comments 1
2 min read
$lookup: more than just a SQL join (understand performance)

$lookup: more than just a SQL join (understand performance)

8
Comments 1
5 min read
Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

1
Comments
8 min read
The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

Comments
2 min read
Understanding Database Schema Structure for Beginners

Understanding Database Schema Structure for Beginners

1
Comments
4 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

2
Comments 2
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.