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.
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

16
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
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
SQL COALESCE in Postgres: A Simple Guide

SQL COALESCE in Postgres: A Simple Guide

14
Comments 7
3 min read
Understanding Database Schema Structure for Beginners

Understanding Database Schema Structure for Beginners

1
Comments
4 min read
Oracle AI Database 26ai — Storing Flashback Logs Outside FRA

Oracle AI Database 26ai — Storing Flashback Logs Outside FRA

Comments
2 min read
"Schema Later" considered harmful 👉🏻 schema validation (enforced data consistency)

"Schema Later" considered harmful 👉🏻 schema validation (enforced data consistency)

1
Comments 2
3 min read
Total under Recursive Relationship — From SQL to SPL #33

Total under Recursive Relationship — From SQL to SPL #33

7
Comments 1
2 min read
Learning PostgreSQL

Learning PostgreSQL

Comments
2 min read
Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)

Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)

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