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.
Building on Aurora DSQL multi-region: the setup notes I wish I'd had

Building on Aurora DSQL multi-region: the setup notes I wish I'd had

Comments
3 min read
A Jepsen-lite witness: prove "sold once" from committed history, not app hope

A Jepsen-lite witness: prove "sold once" from committed history, not app hope

Comments
3 min read
Session 4 summary

Session 4 summary

Comments
2 min read
ActiveRecord: You Wanted a Number, but Loaded 500,000 Rows Into Memory

ActiveRecord: You Wanted a Number, but Loaded 500,000 Rows Into Memory

Comments
6 min read
¿Cómo revertir una migración promovida a Aurora sin perder los datos nuevos?

¿Cómo revertir una migración promovida a Aurora sin perder los datos nuevos?

6
Comments
10 min read
Product Analytics with SQL: Tracking What Actually Matters

Product Analytics with SQL: Tracking What Actually Matters

Comments
6 min read
How I Used Redis to Stop My Football Web App From Hammering the Database

How I Used Redis to Stop My Football Web App From Hammering the Database

Comments
5 min read
Natural-language SQL needs metric contract tests, not just valid SQL

Natural-language SQL needs metric contract tests, not just valid SQL

4
Comments 1
2 min read
Understanding the communication between the server and browser

Understanding the communication between the server and browser

1
Comments
1 min read
1.4.10 Planner Hook: When It Fires, How to Use It

1.4.10 Planner Hook: When It Fires, How to Use It

Comments
9 min read
1.5.3 Join Nodes: NestLoop, HashJoin, MergeJoin

1.5.3 Join Nodes: NestLoop, HashJoin, MergeJoin

Comments
9 min read
1.5 Executor: How Results Come Back

1.5 Executor: How Results Come Back

Comments
4 min read
1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg

1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg

Comments
9 min read
1.4.9 Planner Preprocessing: Subquery Pull-up, Predicate Pushdown, Equivalence Classes

1.4.9 Planner Preprocessing: Subquery Pull-up, Predicate Pushdown, Equivalence Classes

Comments
12 min read
1.4.7 Parallel Cost: When to Go Parallel and How Many Workers

1.4.7 Parallel Cost: When to Go Parallel and How Many Workers

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