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

Isolation

1
Comments
2 min read
Database Migrations in Production: Zero-Downtime Schema Changes (2026 Guide)

Database Migrations in Production: Zero-Downtime Schema Changes (2026 Guide)

Comments
2 min read
Database Connection Pooling: Why Your App Crashes Under Load (Fix Guide 2026)

Database Connection Pooling: Why Your App Crashes Under Load (Fix Guide 2026)

Comments
2 min read
SQL fundamentals: DDL, DML, filtering, and CASE WHEN

SQL fundamentals: DDL, DML, filtering, and CASE WHEN

1
Comments
3 min read
How to Process 1 Million Rows in Laravel Without Crashing Your Server

How to Process 1 Million Rows in Laravel Without Crashing Your Server

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