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.
Single-table DynamoDB design for a real-time game (rooms, rounds, leaderboards)

Single-table DynamoDB design for a real-time game (rooms, rounds, leaderboards)

Comments
3 min read
Day 49: Building Dashboards with ClickHouse® and Apache Superset

Day 49: Building Dashboards with ClickHouse® and Apache Superset

2
Comments
4 min read
Choosing the Right Database Abstraction

Choosing the Right Database Abstraction

Comments
7 min read
Designing a strongly-consistent event exchange on Amazon Aurora DSQL

Designing a strongly-consistent event exchange on Amazon Aurora DSQL

Comments
4 min read
Ghost CMS has 12 tables and 80+ columns. What does each one mean?

Ghost CMS has 12 tables and 80+ columns. What does each one mean?

Comments
3 min read
OCI Database Auto Backup Window Time Slots Reference

OCI Database Auto Backup Window Time Slots Reference

Comments
2 min read
Wait, MongoDB Does That Too?

Wait, MongoDB Does That Too?

Comments
2 min read
When to denormalize, when to join: A ClickHouse guide (2026)

When to denormalize, when to join: A ClickHouse guide (2026)

1
Comments
17 min read
How Database Indexes Actually Work (and When They Backfire)

How Database Indexes Actually Work (and When They Backfire)

Comments
3 min read
Understanding Database Relationships: From Relational Models to Star and Snowflake Schemas

Understanding Database Relationships: From Relational Models to Star and Snowflake Schemas

Comments
3 min read
Day 47 - ClickHouse® Memory Management and Tuning

Day 47 - ClickHouse® Memory Management and Tuning

Comments
6 min read
Day 48 - Sharding Strategies in ClickHouse®

Day 48 - Sharding Strategies in ClickHouse®

Comments
4 min read
Running TigerBeetle without a control plane database. Locking.

Running TigerBeetle without a control plane database. Locking.

Comments
2 min read
Quick Overview of Relationship Schemas and Joins

Quick Overview of Relationship Schemas and Joins

Comments
4 min read
samkhya v1.0: Plug Claude, GPT-4o-mini, or Local Ollama Into Your SQL Query Optimizer

samkhya v1.0: Plug Claude, GPT-4o-mini, or Local Ollama Into Your SQL Query Optimizer

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