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.
Airtable or Traditional Databases: A Practical Framework for Your Next Data System

Airtable or Traditional Databases: A Practical Framework for Your Next Data System

Comments
3 min read
The restore that dropped our staging tables: a foreign key nobody restored

The restore that dropped our staging tables: a foreign key nobody restored

Comments
4 min read
I tested a PostgreSQL migration checker on 760 real migration files

I tested a PostgreSQL migration checker on 760 real migration files

Comments
3 min read
Why does my vector DB retrieval keep returning duplicate noise for my chat agent, and how to fix it?

Why does my vector DB retrieval keep returning duplicate noise for my chat agent, and how to fix it?

1
Comments 2
7 min read
UUID v4 vs UUID v7: Which One Should Developers Use in 2026?

UUID v4 vs UUID v7: Which One Should Developers Use in 2026?

Comments
7 min read
Three bugs that made our time-series queries 680 slower (and how we found them)

Three bugs that made our time-series queries 680 slower (and how we found them)

1
Comments
6 min read
New Percentile and Median Absolute Deviation Aggregations in Manticore

New Percentile and Median Absolute Deviation Aggregations in Manticore

Comments
3 min read
Zero-Downtime PostgreSQL Upgrade: RDS Blue/Green from version 13 to version 18

Zero-Downtime PostgreSQL Upgrade: RDS Blue/Green from version 13 to version 18

Comments
8 min read
Beyond DBUnit and Raw SQL: Type-Safe Database State in Java Tests

Beyond DBUnit and Raw SQL: Type-Safe Database State in Java Tests

Comments
2 min read
Why the Outbox Pattern, Queue, and Embedding Worker?

Why the Outbox Pattern, Queue, and Embedding Worker?

Comments
3 min read
An outbox preserves notification intent; delivery deduplication is a separate boundary

An outbox preserves notification intent; delivery deduplication is a separate boundary

Comments
4 min read
Valkey 9.2's INCREX command removes the crash window between INCR and EXPIRE

Valkey 9.2's INCREX command removes the crash window between INCR and EXPIRE

9
Comments
8 min read
Pagination Done Right: Cursor vs. Offset in Practice

Pagination Done Right: Cursor vs. Offset in Practice

5
Comments
13 min read
I wanted Jepsen's Elle in CI without a JVM, so I wrote adya

I wanted Jepsen's Elle in CI without a JVM, so I wrote adya

Comments 2
7 min read
Querying CSV and Parquet exports inside a SQL IDE with DuckDB

Querying CSV and Parquet exports inside a SQL IDE with DuckDB

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