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.
Storing Billions of Webhook Audit Logs in PostgreSQL: Partitioning, Indexing, Compression, and Retention

Storing Billions of Webhook Audit Logs in PostgreSQL: Partitioning, Indexing, Compression, and Retention

1
Comments 1
22 min read
Database Modeling of a Music Marketplace. Part 1

Database Modeling of a Music Marketplace. Part 1

1
Comments 1
8 min read
How I stream row changes out of SQLite without touching the app (reading the WAL)

How I stream row changes out of SQLite without touching the app (reading the WAL)

Comments
4 min read
Zero-Downtime Database Migrations at Scale: Dual-Writing & Shadow Testing

Zero-Downtime Database Migrations at Scale: Dual-Writing & Shadow Testing

Comments
2 min read
PostgreSQL Table Bloat and Defragmentation: Autovacuum vs VACUUM vs VACUUM FULL

PostgreSQL Table Bloat and Defragmentation: Autovacuum vs VACUUM vs VACUUM FULL

Comments 1
8 min read
Best Databricks Data Modeling Tools (2026): SQLDBM, dbt, erwin & ER/Studio Compared

Best Databricks Data Modeling Tools (2026): SQLDBM, dbt, erwin & ER/Studio Compared

Comments
10 min read
Estrategias de respaldo y recuperaciĂłn de PostgreSQL con Docker, Render y GitHub Actions

Estrategias de respaldo y recuperaciĂłn de PostgreSQL con Docker, Render y GitHub Actions

Comments
12 min read
My AI Agent Kept Missing Deadlines and Double-Posting — Here's How I Fixed It with JSON Interfaces and Idempotency Checks

My AI Agent Kept Missing Deadlines and Double-Posting — Here's How I Fixed It with JSON Interfaces and Idempotency Checks

Comments 1
4 min read
What getting into thirteen database projects' docs actually took

What getting into thirteen database projects' docs actually took

2
Comments
2 min read
Database Engines 101: How They Work, the Main Types, and How to Swap Them in PostgreSQL

Database Engines 101: How They Work, the Main Types, and How to Swap Them in PostgreSQL

1
Comments 2
10 min read
Async LINQ: Why ToListAsync Exists (And Why WhereAsync Doesn't)

Async LINQ: Why ToListAsync Exists (And Why WhereAsync Doesn't)

Comments 1
3 min read
Supabase RLS is great. Here's the part you'll still build yourself.

Supabase RLS is great. Here's the part you'll still build yourself.

Comments
6 min read
Our Dashboard Looked Fine. The Database Was Out of Connections.

Our Dashboard Looked Fine. The Database Was Out of Connections.

Comments
4 min read
RecallOps: Building Persistent Memory for Engineering Incident Response

RecallOps: Building Persistent Memory for Engineering Incident Response

Comments 1
5 min read
PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

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