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.
DuckDB 2.0 alpha's triggers cost three times more per row than per statement

DuckDB 2.0 alpha's triggers cost three times more per row than per statement

4
Comments
7 min read
PostgreSQL 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second

PostgreSQL 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second

8
Comments
6 min read
The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

Comments
4 min read
Corrected vs. ended: two ways a fact stops being true

Corrected vs. ended: two ways a fact stops being true

Comments
10 min read
Flag Office Visits Within 6 Months After Surgery

Flag Office Visits Within 6 Months After Surgery

5
Comments
6 min read
Five things restore-testing Supabase dumps turned up

Five things restore-testing Supabase dumps turned up

1
Comments
5 min read
How to format SQL without uploading your queries

How to format SQL without uploading your queries

Comments
2 min read
Ne počinjite s vektorskom bazom

Ne počinjite s vektorskom bazom

Comments
2 min read
Non partire dal database vettoriale

Non partire dal database vettoriale

Comments
2 min read
Why my database client makes you review every edit before it runs

Why my database client makes you review every edit before it runs

Comments
1 min read
Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

Comments
6 min read
48-Hour Field Notes: I Replayed a Generated Migration Twice and the Row Counts Moved

48-Hour Field Notes: I Replayed a Generated Migration Twice and the Row Counts Moved

Comments
5 min read
Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

Comments
6 min read
Our standby received every change for five hours and applied none of them

Our standby received every change for five hours and applied none of them

Comments
2 min read
Schema Evolution in Financial Data APIs: Versioning Without Breaking Consumers

Schema Evolution in Financial Data APIs: Versioning Without Breaking Consumers

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