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.
Unread badges that would not clear: 59 of my 64 messages were junk

Unread badges that would not clear: 59 of my 64 messages were junk

Comments
3 min read
The Algorithm Behind "Are You Also Experiencing X?"

The Algorithm Behind "Are You Also Experiencing X?"

1
Comments
5 min read
Schema catalogs for AI assistants: the layer nobody wants to maintain

Schema catalogs for AI assistants: the layer nobody wants to maintain

Comments
6 min read
Building a Sales Analytics Data Warehouse with PostgreSQL

Building a Sales Analytics Data Warehouse with PostgreSQL

Comments
3 min read
The N+1 Query Problem: Why Your API Might Be Making 101 Database Queries Instead of 2

The N+1 Query Problem: Why Your API Might Be Making 101 Database Queries Instead of 2

1
Comments
6 min read
Supabase Auth Schema Explained: Users, Identities, Sessions

Supabase Auth Schema Explained: Users, Identities, Sessions

Comments
4 min read
SQL Cheat sheet

SQL Cheat sheet

1
Comments
7 min read
Unread badges that would not clear: 59 of my 64 messages were junk

Unread badges that would not clear: 59 of my 64 messages were junk

Comments 1
3 min read
How to Choose Between SQL, NoSQL, and Everything in Between

How to Choose Between SQL, NoSQL, and Everything in Between

Comments
8 min read
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

Comments
5 min read
Why marketplace accounting becomes so hard

Why marketplace accounting becomes so hard

1
Comments
15 min read
A New Way to Build Aggregation Pipelines in Go

A New Way to Build Aggregation Pipelines in Go

Comments
6 min read
The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL

The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL

Comments
4 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

Comments
7 min read
What is Redis? The Developer’s Secret Weapon for Lightning-Fast Apps

What is Redis? The Developer’s Secret Weapon for Lightning-Fast Apps

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