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.
44/60 Days System Design Questions

44/60 Days System Design Questions

Comments 4
2 min read
The Deadlock That Only Showed Up Under Load: Debugging DB2 SQLCODE -811 in Production

The Deadlock That Only Showed Up Under Load: Debugging DB2 SQLCODE -811 in Production

Comments
5 min read
SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

Comments
9 min read
Customer-Facing Analytics: What Your SaaS App Is Missing (And How to Add It)

Customer-Facing Analytics: What Your SaaS App Is Missing (And How to Add It)

1
Comments
6 min read
Understanding Prisma and Sql — Relationships, Schema, and Querying

Understanding Prisma and Sql — Relationships, Schema, and Querying

1
Comments
10 min read
Half your UUIDs know when they were made. Half don't.

Half your UUIDs know when they were made. Half don't.

Comments
4 min read
The PostgreSQL mental model that finally clicked for me

The PostgreSQL mental model that finally clicked for me

1
Comments
2 min read
Building the In-Memory Store: Strings, Lists, Hashes and Expiry

Building the In-Memory Store: Strings, Lists, Hashes and Expiry

Comments
9 min read
*WALK OF SHAME* We used to call Database-Per-Tenant too expensive. We were wrong

*WALK OF SHAME* We used to call Database-Per-Tenant too expensive. We were wrong

1
Comments
2 min read
GBase 8a High Availability Deep Dive: gcware Quorum, Replica Consistency, and Failover

GBase 8a High Availability Deep Dive: gcware Quorum, Replica Consistency, and Failover

Comments
4 min read
GBase 8a Data Import & Export Guide: gload, LOAD DATA, and SELECT INTO OUTFILE

GBase 8a Data Import & Export Guide: gload, LOAD DATA, and SELECT INTO OUTFILE

Comments
4 min read
GBase 8a Query Optimization in Practice: EXPLAIN, Materialized Views, CTE, and Common Tuning Techniques

GBase 8a Query Optimization in Practice: EXPLAIN, Materialized Views, CTE, and Common Tuning Techniques

Comments
3 min read
Diffing two EXPLAIN plans as trees, not text

Diffing two EXPLAIN plans as trees, not text

Comments
4 min read
GBase 8a Slow Query Troubleshooting and Optimization in Practice

GBase 8a Slow Query Troubleshooting and Optimization in Practice

Comments
3 min read
An Engineer's Guide to DuckDB and Modern OLAP Databases

An Engineer's Guide to DuckDB and Modern OLAP Databases

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