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.
SQL Cheat sheet

SQL Cheat sheet

1
Comments
7 min read
Supabase RLS is great. Here's the part you'll still build yourself.

Supabase RLS is great. Here's the part you'll still build yourself.

Comments 1
6 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
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
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
PostgreSQL 19's WAIT FOR LSN command replaces the read-your-writes polling loop

PostgreSQL 19's WAIT FOR LSN command replaces the read-your-writes polling loop

15
Comments 2
8 min read
Stop building your own vector index: Why managed services are eating the Postgres ecosystem

Stop building your own vector index: Why managed services are eating the Postgres ecosystem

1
Comments 1
5 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
Do Supabase backups include Storage files?

Do Supabase backups include Storage files?

Comments
4 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.