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.
Complete Guide to CloudNativePG 1.29 + PostgreSQL 18 — Production Kubernetes Database Operator Setup

Complete Guide to CloudNativePG 1.29 + PostgreSQL 18 — Production Kubernetes Database Operator Setup

Comments
5 min read
SQL Views Explained: Write Once, Query Forever

SQL Views Explained: Write Once, Query Forever

Comments 1
6 min read
Why I Stopped Using STI and Started Using Delegated Types

Why I Stopped Using STI and Started Using Delegated Types

Comments 1
4 min read
DataAccess: Entity Framework

DataAccess: Entity Framework

5
Comments
5 min read
Anti-Join in MongoDB

Anti-Join in MongoDB

1
Comments
6 min read
When scaling broke my system (and it wasn’t a performance issue)

When scaling broke my system (and it wasn’t a performance issue)

Comments
1 min read
The Gap Between Database Version Control and Release Management

The Gap Between Database Version Control and Release Management

Comments
5 min read
Where should I handle inserting data into multiple related tables: frontend or backend?

Where should I handle inserting data into multiple related tables: frontend or backend?

Comments
1 min read
PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic

PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic

4
Comments 1
6 min read
The Agent Data Layer: A Missing Layer in AI Architecture

The Agent Data Layer: A Missing Layer in AI Architecture

1
Comments
2 min read
Replacing Elasticsearch with ClickHouse : A 90% Cost-Reduction Migration

Replacing Elasticsearch with ClickHouse : A 90% Cost-Reduction Migration

3
Comments
33 min read
What happens when every developer on your team can query production (safely)

What happens when every developer on your team can query production (safely)

Comments
2 min read
Cryogenic Storage: A Developer's Guide (Yes, Really)

Cryogenic Storage: A Developer's Guide (Yes, Really)

Comments
2 min read
How Databases Store Data: B+ Tree Explained Simply for Beginners (With Real-World Examples)

How Databases Store Data: B+ Tree Explained Simply for Beginners (With Real-World Examples)

5
Comments
25 min read
7 PostgreSQL extensions that will supercharge your database in 2026

7 PostgreSQL extensions that will supercharge your database in 2026

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