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.
6 Essential SQL Concepts Every Beginner Should Master

6 Essential SQL Concepts Every Beginner Should Master

1
Comments
2 min read
When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

1
Comments
19 min read
Databasus released physical and incremental backups with WAL streaming for PITR

Databasus released physical and incremental backups with WAL streaming for PITR

Comments
5 min read
Database Indexes Explained: B-Trees, Composite Keys, and When Indexes Hurt Performance (2026)

Database Indexes Explained: B-Trees, Composite Keys, and When Indexes Hurt Performance (2026)

Comments
2 min read
The Slow Query Hidden Inside Your PL/pgSQL Function

The Slow Query Hidden Inside Your PL/pgSQL Function

Comments
5 min read
Event Sourcing Explained: When CRUD Is Not Enough (Practical Guide 2026)

Event Sourcing Explained: When CRUD Is Not Enough (Practical Guide 2026)

Comments
5 min read
How to get near-perfect, deterministic accuracy from your AI agents

How to get near-perfect, deterministic accuracy from your AI agents

22
Comments 1
14 min read
Drizzle ORM in 2026: The Lightweight TypeScript ORM That's Quietly Taking Over

Drizzle ORM in 2026: The Lightweight TypeScript ORM That's Quietly Taking Over

1
Comments
4 min read
Pagination Done Right: Cursor vs Offset and Why It Matters at Scale

Pagination Done Right: Cursor vs Offset and Why It Matters at Scale

Comments
1 min read
Database Transactions: ACID, Isolation Levels, and Deadlocks

Database Transactions: ACID, Isolation Levels, and Deadlocks

Comments
1 min read
Choosing the Right Redis Eviction Policy for Production

Choosing the Right Redis Eviction Policy for Production

Comments
10 min read
PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

Comments
5 min read
Overcoming the N+1 Query Trap in a Custom E-Commerce Backend

Overcoming the N+1 Query Trap in a Custom E-Commerce Backend

1
Comments 1
2 min read
Isolation

Isolation

1
Comments
2 min read
Understanding SQL: DDL, DML, and Data Transformation

Understanding SQL: DDL, DML, and Data Transformation

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