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.
Nullable Is a Rollout Strategy, Not a Domain Model

Nullable Is a Rollout Strategy, Not a Domain Model

Comments 1
3 min read
The N+1 Query Problem: How One Page Fires 2,101 Queries (and How to Get Back to 3)

The N+1 Query Problem: How One Page Fires 2,101 Queries (and How to Get Back to 3)

Comments 5
3 min read
Apache Data Lakehouse Weekly: July 16 to July 23, 2026

Apache Data Lakehouse Weekly: July 16 to July 23, 2026

Comments
25 min read
Your budgeting app is lying to you about last month

Your budgeting app is lying to you about last month

Comments 1
3 min read
How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)

How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)

1
Comments
6 min read
Spring Deep Dive: Transactions

Spring Deep Dive: Transactions

7
Comments 2
7 min read
SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

1
Comments 1
9 min read
Use SQLite STRICT Tables for Agent Control Data

Use SQLite STRICT Tables for Agent Control Data

Comments
3 min read
Where Should the Foreign Key Go?

Where Should the Foreign Key Go?

2
Comments
6 min read
From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19 (beta - reverted)

From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19 (beta - reverted)

1
Comments 1
6 min read
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

Comments
3 min read
Real-Time VPN & Proxy Detection: Why Static IP Databases Are Failing You

Real-Time VPN & Proxy Detection: Why Static IP Databases Are Failing You

Comments
2 min read
Oracle RMAN Recovery Runbook: Restore, Recover, Prove It

Oracle RMAN Recovery Runbook: Restore, Recover, Prove It

Comments
10 min read
The migration that should have been two migrations

The migration that should have been two migrations

Comments 2
4 min read
Why Knowing SQL Isn't Enough to Understand Databases

Why Knowing SQL Isn't Enough to Understand Databases

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