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.
PostgreSQL 2200H Error: Causes and Solutions Complete Guide

PostgreSQL 2200H Error: Causes and Solutions Complete Guide

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

Oracle ORA-00472 Error: Causes and Solutions Complete Guide

Comments
3 min read
Demystifying SSH with -vvv: How GBase 8a's Underlying Connection Negotiates Encryption

Demystifying SSH with -vvv: How GBase 8a's Underlying Connection Negotiates Encryption

2
Comments
3 min read
PostgreSQL 22003 Error: Causes and Solutions Complete Guide

PostgreSQL 22003 Error: Causes and Solutions Complete Guide

Comments 1
3 min read
SQLite Ecosystem: RTree/JSON Bugs, ON CONFLICT DO SELECT & PG Query Planning

SQLite Ecosystem: RTree/JSON Bugs, ON CONFLICT DO SELECT & PG Query Planning

Comments
3 min read
Database Management Systems for Beginners: Learn SQL, Tables, Queries, and Data Design.

Database Management Systems for Beginners: Learn SQL, Tables, Queries, and Data Design.

Comments
1 min read
Transactional Outbox with Kafka: How to Stop Losing Events When Syncing Databases

Transactional Outbox with Kafka: How to Stop Losing Events When Syncing Databases

Comments
2 min read
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
How Database Inserts Work: WAL and Buffer Pools

How Database Inserts Work: WAL and Buffer Pools

Comments
4 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
Cómo eliminé duplicados en la generación de números de factura sin usar locks

Cómo eliminé duplicados en la generación de números de factura sin usar locks

Comments
3 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.