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.
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
SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order

SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order

6
Comments 2
4 min read
Cloudflare Email Worker inbox: store every message in D1 in 30 lines

Cloudflare Email Worker inbox: store every message in D1 in 30 lines

2
Comments 4
5 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
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
Kubernetes Deployments, DaemonSets, and StatefulSets: a Deep Dive from a Production Outage

Kubernetes Deployments, DaemonSets, and StatefulSets: a Deep Dive from a Production Outage

1
Comments 2
10 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
On the second of January we started overwriting last year's orders

On the second of January we started overwriting last year's orders

1
Comments 1
2 min read
SQL vs NoSQL: Which Database Should You Choose in 2026?

SQL vs NoSQL: Which Database Should You Choose in 2026?

Comments
5 min read
I've got feedback from previous project and implement it in new one! (FastAPI + PostgreSQL + External API + Docker)

I've got feedback from previous project and implement it in new one! (FastAPI + PostgreSQL + External API + Docker)

Comments
1 min read
How Cobrainer built graph-based agent memory on one engine

How Cobrainer built graph-based agent memory on one engine

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