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
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
Why Knowing SQL Isn't Enough to Understand Databases

Why Knowing SQL Isn't Enough to Understand Databases

Comments 1
3 min read
Day 26 of 100 Days of ClickHouse: Understanding Distributed Tables

Day 26 of 100 Days of ClickHouse: Understanding Distributed Tables

2
Comments
4 min read
Listening to the Heartbeat of Your Database: Understanding Change Data Capture (CDC)

Listening to the Heartbeat of Your Database: Understanding Change Data Capture (CDC)

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