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.
I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

Comments
5 min read
SQLite WAL Does Not Mean Unlimited Writers: A Practical Python Playbook

SQLite WAL Does Not Mean Unlimited Writers: A Practical Python Playbook

Comments
6 min read
Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

1
Comments 1
7 min read
Enable MySQL HeatWave REST Service (MRS)

Enable MySQL HeatWave REST Service (MRS)

Comments
3 min read
Your seed data is lying to you — the case for foreign-key-consistent test data

Your seed data is lying to you — the case for foreign-key-consistent test data

Comments
2 min read
PostgreSQL Connection Pooling in Go: What I Actually Tune in Production

PostgreSQL Connection Pooling in Go: What I Actually Tune in Production

1
Comments 1
5 min read
GraphRAG vs Neo4j: Which Do You Actually Need?

GraphRAG vs Neo4j: Which Do You Actually Need?

Comments
10 min read
When an App Says “Forget”, What Would It Take to Believe It?

When an App Says “Forget”, What Would It Take to Believe It?

Comments
6 min read
Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?

Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?

Comments
5 min read
Two People Bought the Last Ticket. Both Got a Confirmation Email.

Two People Bought the Last Ticket. Both Got a Confirmation Email.

Comments 1
9 min read
Safer Database Code in FiveM Scripts with oxmysql: Placeholders, Atomic Updates and Transactions

Safer Database Code in FiveM Scripts with oxmysql: Placeholders, Atomic Updates and Transactions

Comments
4 min read
How I Ran a Zero-Downtime Postgres Migration on a 180M-Row Table With Claude Code

How I Ran a Zero-Downtime Postgres Migration on a 180M-Row Table With Claude Code

Comments
7 min read
The Saturday Data Run: 457 Matches, Six Exports, Zero Manual Steps

The Saturday Data Run: 457 Matches, Six Exports, Zero Manual Steps

Comments
2 min read
8 checks that catch offline-first sync bugs before your users do

8 checks that catch offline-first sync bugs before your users do

Comments
4 min read
Visualizing a Mixed-Entity DynamoDB Table: What Schema Inference Reveals—and What It Misses

Visualizing a Mixed-Entity DynamoDB Table: What Schema Inference Reveals—and What It Misses

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