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.
The dual-write problem in NestJS, solved with Drizzle: a transactional outbox + idempotent inbox

The dual-write problem in NestJS, solved with Drizzle: a transactional outbox + idempotent inbox

1
Comments 2
6 min read
Reverse Engineer Any Database into dbdiagram.io, PlantUML, Mermaid, or QuickDBD - Then Keep Designing

Reverse Engineer Any Database into dbdiagram.io, PlantUML, Mermaid, or QuickDBD - Then Keep Designing

Comments
6 min read
PostgreSQL 08004 오류 원인과 해결 방법 완벽 가이드

PostgreSQL 08004 오류 원인과 해결 방법 완벽 가이드

Comments
2 min read
Oracle ORA-00069 오류 원인과 해결 방법 완벽 가이드

Oracle ORA-00069 오류 원인과 해결 방법 완벽 가이드

Comments
2 min read
SQLite Bug 3.52.0, DuckDB Conference Program, & PostgreSQL Logical Replication Deep Dive

SQLite Bug 3.52.0, DuckDB Conference Program, & PostgreSQL Logical Replication Deep Dive

Comments
3 min read
# How I Cut SQL Query Time from 45 Seconds to 8 Seconds

# How I Cut SQL Query Time from 45 Seconds to 8 Seconds

Comments
1 min read
PostgreSQL 08001 오류 원인과 해결 방법 완벽 가이드

PostgreSQL 08001 오류 원인과 해결 방법 완벽 가이드

Comments
2 min read
SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD

SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD

Comments
4 min read
Oracle ORA-00060 오류 원인과 해결 방법 완벽 가이드

Oracle ORA-00060 오류 원인과 해결 방법 완벽 가이드

Comments
3 min read
PostgreSQL 08006 오류 원인과 해결 방법 완벽 가이드

PostgreSQL 08006 오류 원인과 해결 방법 완벽 가이드

Comments
2 min read
Migrations que não quebram em produção — o guia que ninguém te deu

Migrations que não quebram em produção — o guia que ninguém te deu

Comments
4 min read
UUID v4 vs UUID v7 — Lequel choisir pour PostgreSQL en 2026 ?

UUID v4 vs UUID v7 — Lequel choisir pour PostgreSQL en 2026 ?

Comments
4 min read
Day 56 – Mastering ClickHouse® AggregatingMergeTree: Build Faster Analytics with Pre-Aggregated Data

Day 56 – Mastering ClickHouse® AggregatingMergeTree: Build Faster Analytics with Pre-Aggregated Data

Comments 2
5 min read
Extended RUM in DocumentDB: B-tree-like ordered scans for flexible BSON in PostgreSQL

Extended RUM in DocumentDB: B-tree-like ordered scans for flexible BSON in PostgreSQL

Comments
15 min read
How I Migrated 10,000+ Records with Zero Downtime

How I Migrated 10,000+ Records with Zero Downtime

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.