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.
Stage 2: Profile the Source

Stage 2: Profile the Source

Comments
4 min read
Run AI-Written Migrations on a Throwaway Database Before They Touch Yours

Run AI-Written Migrations on a Throwaway Database Before They Touch Yours

Comments 1
4 min read
Why Postgres and Cassandra Made Opposite Bets on Storage Engines

Why Postgres and Cassandra Made Opposite Bets on Storage Engines

Comments
6 min read
The Past Keeps Changing

The Past Keeps Changing

3
Comments
11 min read
I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

Comments
4 min read
Your acquisitions table needs a status field, not a boolean

Your acquisitions table needs a status field, not a boolean

Comments
2 min read
Postgres Says "Too Many Clients Already": Diagnose It Before You Add a Pooler

Postgres Says "Too Many Clients Already": Diagnose It Before You Add a Pooler

Comments 2
7 min read
One docker compose up, One Seeded Postgres

One docker compose up, One Seeded Postgres

Comments
6 min read
Prisma Postgres Seed: prisma db seed, psql, and the Direct URL

Prisma Postgres Seed: prisma db seed, psql, and the Direct URL

Comments
19 min read
Nine of Thirteen Corrections Were Wrong: The Fix That Came With a Proof It Couldn't Work

Nine of Thirteen Corrections Were Wrong: The Fix That Came With a Proof It Couldn't Work

Comments 2
10 min read
Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

Comments
9 min read
What is Information Schema in PostgreSQL?

What is Information Schema in PostgreSQL?

Comments
2 min read
How We Reduced Our SQLite Database from 8.7GB to 3.8GB Without Downtime

How We Reduced Our SQLite Database from 8.7GB to 3.8GB Without Downtime

Comments
2 min read
Stage 7: Freeze, Cutover, Bridge

Stage 7: Freeze, Cutover, Bridge

Comments
5 min read
Stage 3: Map the Fields

Stage 3: Map the Fields

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