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.
Read Replicas vs Sharding Explained Simply: When to Scale Reads vs When to Split Data

Read Replicas vs Sharding Explained Simply: When to Scale Reads vs When to Split Data

Comments
3 min read
Day 13 of #100DaysOfClickHouse: Understanding Partitions vs Sorting Keys

Day 13 of #100DaysOfClickHouse: Understanding Partitions vs Sorting Keys

1
Comments
1 min read
Redis Isn't Just a Cache: 14 Use Cases (System Design)

Redis Isn't Just a Cache: 14 Use Cases (System Design)

2
Comments 2
1 min read
What Designing a Binary Protocol Actually Taught Me

What Designing a Binary Protocol Actually Taught Me

Comments 1
8 min read
Database Migration Strategies for Next.js and Supabase Production Apps

Database Migration Strategies for Next.js and Supabase Production Apps

2
Comments
6 min read
Day 35/60 System Design Questions

Day 35/60 System Design Questions

1
Comments 4
2 min read
Day 11 of #100DaysOfClickHouse: Exporting Data from ClickHouse® - Formats, Methods, and Best Practices

Day 11 of #100DaysOfClickHouse: Exporting Data from ClickHouse® - Formats, Methods, and Best Practices

1
Comments
3 min read
Oracle ORA-00447 Error: Causes and Solutions Complete Guide

Oracle ORA-00447 Error: Causes and Solutions Complete Guide

1
Comments
3 min read
I Built an LSM-Tree in Pure Python and Finally Understood How RocksDB and Cassandra Handle Millions of Writes

I Built an LSM-Tree in Pure Python and Finally Understood How RocksDB and Cassandra Handle Millions of Writes

Comments
6 min read
PostgreSQL 2200G Error: Causes and Solutions Complete Guide

PostgreSQL 2200G Error: Causes and Solutions Complete Guide

1
Comments
3 min read
Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

1
Comments
7 min read
Stop Doing It Manually: A Production-Ready Bash Engine to Automate Oracle 19c CPU & RU Patching

Stop Doing It Manually: A Production-Ready Bash Engine to Automate Oracle 19c CPU & RU Patching

Comments
2 min read
Why Historical Troubleshooting Is Harder Than It Should Be

Why Historical Troubleshooting Is Harder Than It Should Be

1
Comments
1 min read
I Contributed to Chroma's Open-Source Docs — Here's What I Changed and What I Learned

I Contributed to Chroma's Open-Source Docs — Here's What I Changed and What I Learned

Comments
4 min read
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.