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.
"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior

"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior

Comments
2 min read
How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

Comments
7 min read
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
VisuaLeaf as a MongoDB Compass Alternative

VisuaLeaf as a MongoDB Compass Alternative

9
Comments
5 min read
I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

10
Comments 2
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
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
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
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
Why I Switched from ChromaDB to ElasticSearch (and What I Miss)

Why I Switched from ChromaDB to ElasticSearch (and What I Miss)

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