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.
How NULL Values Skew Comparisons, Aggregations, and Deduplication in GBase 8a

How NULL Values Skew Comparisons, Aggregations, and Deduplication in GBase 8a

2
Comments
3 min read
The Database Architect Teaches His Nephew — Part 2: How Small Things Quietly Break Big Databases

The Database Architect Teaches His Nephew — Part 2: How Small Things Quietly Break Big Databases

Comments
10 min read
How Implicit Type Conversion Causes Wrong Filtering and Join Results in GBase 8a

How Implicit Type Conversion Causes Wrong Filtering and Join Results in GBase 8a

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

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

Comments
3 min read
12 Postgres schemas every B2B SaaS re-implements (and gets wrong the first time)

12 Postgres schemas every B2B SaaS re-implements (and gets wrong the first time)

Comments
3 min read
Transaction Commit Granularity and Rollback Boundaries in GBase 8a Batch Jobs

Transaction Commit Granularity and Rollback Boundaries in GBase 8a Batch Jobs

2
Comments
3 min read
GBase 8a Slow SQL Diagnosis: 6 Real‑World Cases from Symptom to Fix

GBase 8a Slow SQL Diagnosis: 6 Real‑World Cases from Symptom to Fix

2
Comments
3 min read
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
Oracle ORA-00069 오류 원인과 해결 방법 완벽 가이드

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

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

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

Comments
2 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
Running TigerBeetle without a control plane database. Part two.

Running TigerBeetle without a control plane database. Part two.

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

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

Comments
2 min read
database/sql in Go: NullString, Contexts, and Connection Lifecycle

database/sql in Go: NullString, Contexts, and Connection Lifecycle

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