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.
Valkey vs Redis in 2026: What Is Different and What Breaks When You Switch

Valkey vs Redis in 2026: What Is Different and What Breaks When You Switch

Comments
11 min read
Cloudflare Offers 1,500 Connections. Your Database Needs a Budget.

Cloudflare Offers 1,500 Connections. Your Database Needs a Budget.

1
Comments
4 min read
The Database Scaling Ladder: Fix a Slow Database in the Right Order

The Database Scaling Ladder: Fix a Slow Database in the Right Order

Comments
4 min read
SQL Query Cheat Sheet: Essential Queries and Patterns

SQL Query Cheat Sheet: Essential Queries and Patterns

Comments 1
11 min read
Your UNIQUE constraint in PostgreSQL lets duplicates through. Here is how to find every one

Your UNIQUE constraint in PostgreSQL lets duplicates through. Here is how to find every one

Comments
8 min read
I built GenerateRealData, a test data generator where keys, totals and rules hold across tables

I built GenerateRealData, a test data generator where keys, totals and rules hold across tables

Comments
4 min read
Decided Is Not Enforced: two advisories, one pattern

Decided Is Not Enforced: two advisories, one pattern

Comments 1
2 min read
Reconcile warehouse inventory from an opening balance and movement events

Reconcile warehouse inventory from an opening balance and movement events

Comments
2 min read
Electronic Batch Record Requirements: What FDA 483s Cite Under 21 CFR 211.100 and 211.188

Electronic Batch Record Requirements: What FDA 483s Cite Under 21 CFR 211.100 and 211.188

Comments
7 min read
Building the Open Data Lakehouse: An End-to-End Architecture Guide

Building the Open Data Lakehouse: An End-to-End Architecture Guide

Comments
5 min read
A filtered DynamoDB Scan still reads the whole table

A filtered DynamoDB Scan still reads the whole table

Comments
3 min read
Detecting Duplicate Email Records Using Oracle AI Database 26ai and SQL

Detecting Duplicate Email Records Using Oracle AI Database 26ai and SQL

Comments
8 min read
Apache Data Lakehouse Weekly: November 3 to 11, 2026

Apache Data Lakehouse Weekly: November 3 to 11, 2026

1
Comments
28 min read
Mastering SQL Anti-Joins: Finding Missing Records with LEFT JOIN and IS NULL

Mastering SQL Anti-Joins: Finding Missing Records with LEFT JOIN and IS NULL

1
Comments
2 min read
What does uninstalling an Odoo module really delete? I measured it for CRM

What does uninstalling an Odoo module really delete? I measured it for CRM

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